Hi Erwin!
Most probable causes are:
** Windows 95/98/ME
Too much accumulated junk in:
C:\Windows\Temp folder
** Windows NT/2000/XP
Too much accumulated junk in:
C:\Documents and Settings\<user>\local settings\temp folder
** Excel 95/97/2000
Bloated Excel.xlb or Excel10.xlb file. I think that this has been
cured in Excel 2002 (XP) as I've not seen any reports of it happening.
Cures are:
Close down and re-start the computer so as to make sure that you've
finished any incomplete installations that use the tem folder.
The empty the tem folder of all files.
With bloated xlb file, locate the file using:
Start > Search > For files and folders
Search for *.xlb
If it is above around 30KB then it is bloating and should be deleted.
(Save a copy if you like but I don't think that much in terms of
toolbar modifications etc can be restored from a bloated file)
Further references:
Opening/Saving Bottlenecks (Charles Williams)
http://www.decisionmodels.com/optspeedd.htm#OpSave
Troubleshoot Startup Problems(MS):
http://support.microsoft.com/default.aspx?scid=kb;en-us;280504
Some tips on overcoming slow response (David McRitchie)
http://www.mvps.org/dmcritchie/excel/slowresp.htm
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
