CLR wrote:
Hi All......
I have a 10MB Excel file that will "save" in about 30 seconds. As soon as I
hit the save button, the Disk-activity light starts flashing. But, when I do
a "Save-as" to just change the name, it takes a total of 6 minutes. It
starts out with the Status bar saying "Calculating cells" but it stays at
zero for over 3 minutes, then works it's way up slowly every 15 seconds or so
and when it changes to "Saving, filename" the Disk-activity light starts to
flash and it only takes the normal 30 seconds from that point.......
I do have about 40 sheets, with LOTS of VLOOKUPS, but I don't understand the
difference between the SAVE and the SAVEAS times......
Can anyone please explain, and hopefully tell me what I might can do to cut
down the difference in time?
TIA
Vaya con Dios,
Chuck, CABGx3
As an experiment, have you tried to turn off auto-calculation and "Recalculate
before save" before doing the SaveAs? It can make a dramatic difference sometimes.
Also, are you saving over a network or directly in your local hard drive?
I have some files of about 10MB in which I keep calculation set to manual to
speed things up. I can edit things to my heart's content quickly, then push F9
to force a manual calculation when necessary.
ToolsOptionsCalculationTab
Bill
|