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. |
All times are GMT +1. The time now is 05:58 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com