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?
Bookmarks