Home |
Search |
Today's Posts |
#1
|
|||
|
|||
File saves ok, SaveAs VERY slow
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Save and Saveas Greyed out on tool bar and file menu | Setting up and Configuration of Excel | |||
hidden rows & columns slow file open | Excel Discussion (Misc queries) | |||
Open file Slow on Excel 2003 | Excel Discussion (Misc queries) | |||
Macros making file saving extremely slow. | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) |