Excel slows down when linking between sheets

Copper Contributor

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 always slow down and sometimes works like a charm but others i have a delay of maybe a minute or couple of minutes at times.

Also this lag doesn't seem to be there if i just type the sheet and cell location instead of using the usual method of = and looking for the sheet and cell i want to link. 

 

I was wondering if someone has had the same problem before and if you have any tips on how to solve.

9 Replies
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)?
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
Are there any broken drive letter associations with network paths by any chance?
thanks for the reply
No its not the case
This happens to me all of the time as well. In fact it takes longer to link between tabs than it does between files.