Slow Excel docLocked
I have one Excel doc I’m developing–8 pages, pretty simple macros, no VBA, and as it’s grown, so has the save time and the work transactions on the doc. I keep it on a portable drive, and it acts the same on my networked work computer and my standalone home computer (both on MS XP). It’s 4.7 MB, and none of my other Excel docs are giving me this problem, including bigger ones. I re-did a lot of the formatting to actual cells used (not the whole row or column), tried several of the on-line suggestions, but one page seems to be the culprit–if I copy it to another doc, and delete it from the main doc, speed improves.
Any suggestions other than taking the considerable time to reconstruct each possible offending page?