How do I update data in linked cells without opening source workbo

[Guest]

I have cells linked in a destination workbook to a source workbook that is in
a separate folder. If I open the destination, the cells display "#REF" until
I open the source. How do I update the values without having to open the
source workbook? If it is not possible to do that, how do I set a command to
automatically open all related files?

 

[shail]

Hi,

When you open a destination workbook, you must be getting a message to
update the workbook because it is linked with some other workbook.
Don't update it, click "No". And you will get the functions as it was
entered before.

Hope this will work for you.


Thanks

Shail