Saving Excel files takes a huge amount of time

[Heavy Excel user]

Hi,

Excel takes 5-10 minutes whenever I try to save the file after making the
smallest of changes, even if I add a value to just one cell. Excel is using
98 or 99%
of the CPU during these 5-10 minutes.

If I do a save as the file gets saved instantaneously. The save time for
subsequent saves also decreased. Then it slowly started creeping up and now I
am back at a situation where it takes 5-10 minutes

The file size is 3MB with 2 tabs, lots of formulaes, also formulaes cross
referencing the tabs. This is the raw data file, which I am having problem
saving.

There are 2 other excel files which access this data file, one provides
charts and the other provide summarized reports. Thus both these files link
to the data file, but are not linked by any other file.

It almost seems like the save time increases with the age of the excel file
or as a result of the accumulated changes. When you do a save as both of
these are reset !!!! Please help

[Niek Otten]

Often cited advice: turn off Journaling in Outlook (doesn't matter that you
don't use Outlook a lot)

--
Kind regards,

Niek Otten

"Heavy Excel user" <Heavy Excel user@discussions.microsoft.com> wrote in
message news:00DC848E-5E72-473E-801A-B44C55263F04@microsoft.com...
> Hi,
>
> Excel takes 5-10 minutes whenever I try to save the file after making the
> smallest of changes, even if I add a value to just one cell. Excel is
> using
> 98 or 99%
> of the CPU during these 5-10 minutes.
>
> If I do a save as the file gets saved instantaneously. The save time for
> subsequent saves also decreased. Then it slowly started creeping up and
> now I
> am back at a situation where it takes 5-10 minutes
>
> The file size is 3MB with 2 tabs, lots of formulaes, also formulaes cross
> referencing the tabs. This is the raw data file, which I am having problem
> saving.
>
> There are 2 other excel files which access this data file, one provides
> charts and the other provide summarized reports. Thus both these files
> link
> to the data file, but are not linked by any other file.
>
> It almost seems like the save time increases with the age of the excel
> file
> or as a result of the accumulated changes. When you do a save as both of
> these are reset !!!! Please help

[Heavy Excel user]

Journaling is not enabled . . . Based on this advise on other posts I had
already checked that . . . Thanks anyway . . . .

"Niek Otten" wrote:

> Often cited advice: turn off Journaling in Outlook (doesn't matter that you
> don't use Outlook a lot)
>
> --
> Kind regards,
>
> Niek Otten
>
> "Heavy Excel user" <Heavy Excel user@discussions.microsoft.com> wrote in
> message news:00DC848E-5E72-473E-801A-B44C55263F04@microsoft.com...
> > Hi,
> >
> > Excel takes 5-10 minutes whenever I try to save the file after making the
> > smallest of changes, even if I add a value to just one cell. Excel is
> > using
> > 98 or 99%
> > of the CPU during these 5-10 minutes.
> >
> > If I do a save as the file gets saved instantaneously. The save time for
> > subsequent saves also decreased. Then it slowly started creeping up and
> > now I
> > am back at a situation where it takes 5-10 minutes
> >
> > The file size is 3MB with 2 tabs, lots of formulaes, also formulaes cross
> > referencing the tabs. This is the raw data file, which I am having problem
> > saving.
> >
> > There are 2 other excel files which access this data file, one provides
> > charts and the other provide summarized reports. Thus both these files
> > link
> > to the data file, but are not linked by any other file.
> >
> > It almost seems like the save time increases with the age of the excel
> > file
> > or as a result of the accumulated changes. When you do a save as both of
> > these are reset !!!! Please help
>
>
>

[tony h]

does the file size reduce when you do a "save as"?

[Heavy Excel user]

I had checked it earlier and it does not reduce in size . . .

"tony h" wrote:

>
> does the file size reduce when you do a "save as"?
>
>
> --
> tony h
> ------------------------------------------------------------------------
> tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
> View this thread: http://www.excelforum.com/showthread...hreadid=500582
>
>

[Gary''s Student]

There are many reasons for slow saving. One thing to try is to avoid saving
on a network drive and to disconect all network drives before attempting to
save.
--
Gary''s Student


"Heavy Excel user" wrote:

> Hi,
>
> Excel takes 5-10 minutes whenever I try to save the file after making the
> smallest of changes, even if I add a value to just one cell. Excel is using
> 98 or 99%
> of the CPU during these 5-10 minutes.
>
> If I do a save as the file gets saved instantaneously. The save time for
> subsequent saves also decreased. Then it slowly started creeping up and now I
> am back at a situation where it takes 5-10 minutes
>
> The file size is 3MB with 2 tabs, lots of formulaes, also formulaes cross
> referencing the tabs. This is the raw data file, which I am having problem
> saving.
>
> There are 2 other excel files which access this data file, one provides
> charts and the other provide summarized reports. Thus both these files link
> to the data file, but are not linked by any other file.
>
> It almost seems like the save time increases with the age of the excel file
> or as a result of the accumulated changes. When you do a save as both of
> these are reset !!!! Please help

[Heavy Excel user]

I am not saving to network drives. If it were an issue with network files I
would have faced a problem while saving any excel file not just this one.
Just to verify I deleted the one network drive I had as well as deleted all
the shortcuts to network folders under nethood. Not much difference in
performance

"Gary''s Student" wrote:

> There are many reasons for slow saving. One thing to try is to avoid saving
> on a network drive and to disconect all network drives before attempting to
> save.
> --
> Gary''s Student
>
>
> "Heavy Excel user" wrote:
>
> > Hi,
> >
> > Excel takes 5-10 minutes whenever I try to save the file after making the
> > smallest of changes, even if I add a value to just one cell. Excel is using
> > 98 or 99%
> > of the CPU during these 5-10 minutes.
> >
> > If I do a save as the file gets saved instantaneously. The save time for
> > subsequent saves also decreased. Then it slowly started creeping up and now I
> > am back at a situation where it takes 5-10 minutes
> >
> > The file size is 3MB with 2 tabs, lots of formulaes, also formulaes cross
> > referencing the tabs. This is the raw data file, which I am having problem
> > saving.
> >
> > There are 2 other excel files which access this data file, one provides
> > charts and the other provide summarized reports. Thus both these files link
> > to the data file, but are not linked by any other file.
> >
> > It almost seems like the save time increases with the age of the excel file
> > or as a result of the accumulated changes. When you do a save as both of
> > these are reset !!!! Please help