Excel slow to load blank workbook on startup

  • Thread starter Thread starter Dave F.
  • Start date Start date
D

Dave F.

Hi
Excel 2003

Excel opens quickly to display the program frame but with the grey
background instead of the cells of the initial worksheet.

About 5-10 seconds later it loads the worksheet.

It might be loading it from our companies slow server.

What is the standard workbook that it's trying to load? What is it called?
Is there path to it in Options? If there is I can't see it :-(

Hope you can help me.

Cheers
Dave F.
 
Excel isn't like MSWord. There are no standard workbooks that have to be opened
when excel opens.

Each user does have the option of adding any workbooks he or she wants in a
couple of locations.

One is a folder called XLStart -- use windows start button|Search to find it.

Another is user selectable via:
tools|options|general tab
in the "At startup, open all files in:" box.

One of the things that excel does is load the excel toolbar file.

You may want to find that and change the name to see if that's what's causing
the slowdown.

Close excel
Windows start button|Search
look for *.xlb
in hidden folders

Rename them all to *.xlbOLD and restart excel to see if it helps.

If it doesn't help, rename them back to *.xlb.

If it does, delete those *.xlbOLD files and recreate any customized toolbars.

If it didn't work, then the next step will be doing some detective work.

Chip Pearson has some notes on how to diagnose startup errors:
http://www.cpearson.com/excel/StartupErrors.htm

And Jan Karel Pieterse has more notes:
http://www.jkp-ads.com/Articles/StartupProblems.asp
 
Back
Top