Hi Preet!
If that fails, locate the Excel.xlb or Excel10.xlb file using Start >
Search > For Files and Folders. The xlb file should not be above
around 30kb and is usually much smaller. If it is bloated, there’s not
a lot that can be done with it but you should move it from it’s
current location.
The xlb file is where Excel stores your toolbar settings and any
special toolbars or buttons that you create. Don’t worry about the
absence of one of these files. When Excel completes the next
successful open and close, you will find it has created a new file.
As a precautionary measure. Once you have done any messing about with
your toolbars to get them how you want or to add new toolbars or
buttons, you should take a backup copy of it. If it bloats again, at
least you won't have to go back to scratch.
References to Slow Open / Save Problems:
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.