Thread: How do I update data in linked cells without opening source workbo
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TIII TIII is offline
external usenet poster
  
Posts: 1
Default How do I update data in linked cells without opening source workbo
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?
Reply With QuoteReply With Quote