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? |
How do I update data in linked cells without opening source workbo
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 TIII wrote: 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? |
All times are GMT +1. The time now is 02:52 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com