Linking Cells in Different Workbooks

[ecuevas]

Hey, we're trying to set up a link between two workbooks in excel 2003. Basically we want to copy rows of input into the new workbook and have it automatically update whenever information in the original workbook is changed. However, the information includes words as well numbers and I don't know how to make the link accept the information.
It just pops up #VALUE. What can I add to the formula to make it accept words in the cells?

 

[ajetrumpet]

the information includes words as well numbers and I don't know how to make the link accept the information.
It just pops up #VALUE. What can I add to the formula to make it accept words in the cells?

This link might be of interest to you...
http://support.microsoft.com/kb/291047/en-us Take a look at the loop code in method 6.

Also, reference syntax for worksheets in the same workbook is

=SheetName!(DesiredArray)

 

[DanG]

I could be wrong, but here's how I understand that whole thing...

You can reference any sheet/workbook you want, but you must have the other worksheet open when you do the update and then depending on the formula/function you are using should be able to pass text values.

"Sumproduct" is the only function I know that will allow you to not have the other workbooks open. But Sumproduct only passes numbers.

Maybe another approach would allow you to use sumproduct as it is VERY powerful.

HTH.

 

[shades]

One possibility (without seeing your specific needs) is to use the INDEX function. I have used that for rather large workbooks that feed other workbooks. Keep in mind that I always open the base workbook first, then the one to be updated. Then there isn't any "updating" dialogs to contend with.
________
Fake Weed

 

[ecuevas]

One possibility (without seeing your specific needs) is to use the INDEX function.

This could work. Thanks Shades.