Forum Discussion
One worksheet causes severe "not responding" delay on saving/scrolling
Where exactly does the file you are editing "live"? Is it on a shared network drive? Or on your own desktop?
I ask, because with some documents my experience has been that performing tasks like this over a network can prove problematic for a lot of reasons: it may be a transient issue during file server backups; it might be a slower network connection between your desktop and the file server... Anyway one thing to check would be to save a copy of the document to your desktop and see if the behavior continues. It would help narrow down whether some network issue is part of the cause, or if it's some issue with the document itself.
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?