Forum Discussion
Excel slows down when linking between sheets
Hello, I am experiencing a very strange lag when linking between sheets and what is strange is it is not entirely consistent i.e. when linking the same information to different sheets it doesn't ...
Is this on one particular file?
You say the problem does not always happen, but if it does, is it with the same worksheet(s)?
You say the problem does not always happen, but if it does, is it with the same worksheet(s)?
It seems to happen only on this particular file and can occur on any of the worksheets(only when i link) Could it be just because the file has 120+ worksheets.
- Does the problem stop if you set calculation to manual? In that case your workbook needs optimizing.
- No the problem still persists even with calculations set to manual. I'll try to optimize the file. Also interestingly every time it freezes it doesn't show in task manager as non responsive even though i can only minimize the window.
Slun4o If you open the Selection task pane (Home tab, click the "Find & Select" drop-down and choose "Selection pane") and select your sheets in turn, are there any that have many objects listed?