Excel 2003 very, very slow compared to Excel 97

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

I have an excel sheet with some tables, some vloopup, and some images that
are swapped depending on some calculations.

In Ecxel 97 this sheet runs good, no delays are noticeable.

When I load the same sheet on a similar computer with excel 2003, the sheet
becomes, slow, very very slow.

What is wrong with Excel 2003, did it collapse under all the bells and
whistles, or the fancy screens ?

Or is it a setting that is wrong.

Anyone out there with an Idea how to crack this one?

Thanks in advance,


Jan
The Netherlands
 
Jan

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

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

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


Gord Dibben Excel MVP
 
Back
Top