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 |
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 |
All times are GMT +1. The time now is 07:44 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com