Forum Discussion
One worksheet causes severe "not responding" delay on saving/scrolling
hi, I'm using Excel/Office 2016 on windows 10. i have a workbook (xlsx, approx 4Mb) with multiple sheets. Saving it causes the Excel window to go "white" with a "not responding" for 20-30 se...
tks
it was on a shared drive, but i'd already copied it to my documents folder before doing the above tests.
K
it was on a shared drive, but i'd already copied it to my documents folder before doing the above tests.
K
So, if it is still happening on your own desktop, and this doesn't happen at all on other documents locally, you've definitely narrowed things down to the file itself.
You said that copying the sheets into a blank workbook worked. Can you do that with each page, saving as you go? That might 100% solve your issue...or at least it would help you narrow down on which sheet the trouble lies?
- tks,
if you re-read my original post, you'll notice that i've already narrowed it down to one sheet and that copying/pasting the formulae causes a complete hang but that pasting the values is the thing that works. perhaps i wasn't clear! :)
KI did see that, thanks...so, those external file references in this sheet that you referred to... Those have been moved to your local desktop as well? And they have been troubleshot in the same way?
- no i edited the relevant VLOOKUPs to make the references local to the workbook, they had been originally copied from another similar workbook and so had absolute paths in them, which i removed, just leaving the lines looking like this:
=IF(B120>0,VLOOKUP(B120,Customers!$A$1:$G$999,2,FALSE)," ")
K