Home |
Search |
Today's Posts |
#1
|
|||
|
|||
External Links not updating
I had a workbook which I split into two books (for size reasons) containing
several worksheets each. These are accessed using Excel 2000 & XP 2003 The two books have links going both ways. Book A contains a data entry sheet and a report Sheet - amongst others. Book B contains calculation sheets - with the answers linking back to the Report sheet in Book A. If both books are open then everything works fine. However, if only Book A is open then links in that file do not update from Book B, even though a manual update returns no errors - ie OK. If Book B is opened without Book A then those links in Book B do update. The problem only appears to occur when Book A is opened without Book B - causing values in the report sheet not to update. Both files are in the same directory. Does anyone have any ideas on this one? Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Links updating? | Excel Discussion (Misc queries) | |||
Excel 2003: Temporarily "turning off" links to external files... | Excel Discussion (Misc queries) | |||
External links | Excel Discussion (Misc queries) | |||
External Links on open and Excel 2003 | Excel Discussion (Misc queries) | |||
Using variable in external links | Excel Discussion (Misc queries) |