View Single Post
  #4   Report Post  
Bill Martin -- (Remove NOSPAM from address)
 
Posts: n/a
Default

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