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
Bookmarks