| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Time Required to Save a File
I have a large Excel file that takes about 15 seconds to save if I have two
other files open that the first file is linked to. If I do not have these two other files open it takes several minutes to save the first file. Does anyone know what is causing this, and if it can be fixed? I do not always remember to open the other two files so I am frequently stuck waiting for the first file to save. Thanks, John |
|
#2
|
|||
|
|||
|
Do you have calculation set to manual?
There's an option to recalculate before you save. Tools|options|calculation tab If you have manual calculation set, you could turn off the option to recalc before save. Any chance? John M wrote: I have a large Excel file that takes about 15 seconds to save if I have two other files open that the first file is linked to. If I do not have these two other files open it takes several minutes to save the first file. Does anyone know what is causing this, and if it can be fixed? I do not always remember to open the other two files so I am frequently stuck waiting for the first file to save. Thanks, John -- Dave Peterson |
| Reply |
| 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 | |||
| When I save a file I consistently get a message about saving a co. | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
| Save & Save As features in file menu of Excel | Excel Discussion (Misc queries) | |||
| Deleting custom Commands from File Menu are nor saved next time w. | Excel Worksheet Functions | |||
Linear Mode
