ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Why does my Excel workbook take so long to update links? (https://www.excelbanter.com/excel-discussion-misc-queries/37027-why-does-my-excel-workbook-take-so-long-update-links.html)

Bannor

Why does my Excel workbook take so long to update links?
 
I have an Excel 2003 workbook that has several links to other workbooks. When
I open it and update the links, it takes about 30 seconds to update, during
which time my PC slows almost to a standstill. Windows will report Excel as
'not responding' until the update is finished. My other files (with similar
links) take no longer than about 3 seconds. What could the problem be? How
can I fix it? I have run defrag, etc - makes no difference.


All times are GMT +1. The time now is 03:57 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com