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 ...
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?
- I have the same problem in few files. excel lags when linking cell between sheets of same workbook.
I tried clearing all conditional formatting
Reinstalled office 365
closed one drive sync
but the problem still exists