Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
Update data without opening file? | Excel Discussion (Misc queries) | |||
Charts not recognizing source data if original linked data is changed. | Charts and Charting in Excel | |||
Update linked cells within a workbook??? | Links and Linking in Excel | |||
Excel '02: does it allow source files (linked cells) to be opened. | Excel Discussion (Misc queries) |