Slow Saving Workbook

H

Hans

I have a workbook of about 750KB with some 50 more or less
the same worksheets. When I saved it, it used to be saved
right away (within a second), but now it takes some 8 to
10 seconds, while, as far as i know, no significant
changes have been made.

This file does not contain any external links, macros,
names or complicated formulas. It contains some
hyperlinks, but they refer to sheets within the workbook.

Any idea what might be wrong?

regards,
Hans
 
F

Frank Kabel

Hi Hans
below a repost from Gord Dibben:

------
A lot of "slow" Excel problems are caused by too many files in your
Windows\Temp folders.

Clear out your Windows\Temp folder.(see notes below)

If using WinXP another Temp folder would be in your

Documents and Settings\User\Local Settings\Temp

If you are a Net, the Temp folder could be just about anywhere.

Notes on deleting Windows\Temp files............

Re-boot to make sure there are no Temp files being used by
Windows(program
installs, updates etc.) It is easy to forget that when Windows stated
"Your
Computer needs to re-boot to complete this update. Re-boot Now?" and
you
clicked "No, I'll do it later". The files are stored in Windows\Temp
folder.
If you delete them before a re-boot, you can hoop whatever was going
on.

After the re-boot, select all files in Windows\Temp folder and delete.

Also in Documents and Settings\User\Local Settings\Temp

Another item to check is Outlook Journalling. If it is checked "on" it
will
slow down saves. Tools>Options>Journal Options.

For more help on speeding up Excel see Charles Williams' site.

http://www.decisionmodels.com/optspeedb.htm
 
H

Hans

Hi Frank

Thanks for your reply, but I already looked at the
decisionmodels site but I couldnt find anything useful...

Its rather irritating: both files have the same size (some
750KB), but the the original one can be saved right away,
while the other takes 7-8 seconds to save. I checked on
links, names, last cells etc, but I couldnt find anything
unusual...

regards,
Hans
 
Top