Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |