View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default Excel file opens slowly

I don't have a real guess.

Can you rebuild that workbook and see if that helps?

Marcel wrote:

I ran excel in safe mode, but the file still opens slowly. I also read
suggestions from the links you provided. But I don't quite understand as to
why this is the only excel file that opens slowly. If there was a problem,
wouldn't other files open slowly too?

I think it may be this one particular file, but why can I open the file in a
much older computer with no problem?

Again thanks for your help.

"Dave Peterson" wrote:

I think that someone just suggested changing printer drivers when this happened
and it worked for the original poster.

I'd try opening excel in safe mode
close excel
windows start button|run
excel /safe

Then file|open the workbook

If it works more quickly there, maybe it's the excel toolbar that's causing
trouble.

If it works more quickly, you could verify that it is the toolbar file, by:
close excel
windows search
search for *.xlb
(in hidden folders for hidden files, too)

Rename all the *.xlb files you find to *.xlbOLD

Then restart excel and see if that helps.

If it does, then rebuild any customized changes to the toolbar at your
convenience.

If it doesn't, then close excel and rename all those *.xlbOLD back to *.xlb.

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

And Jan Karel Pieterse has more notes at:
http://www.jkp-ads.com/Articles/StartupProblems.htm

Marcel wrote:

I actually saw your suggestion when you replied to another person with the
same problem. I thought my case wasn't quite the same because I could open
an even larger file with no problem.

Anyway, I did clear the temp folder and it still takes over 3 minutes to
open. I do appreciate your help though. And I'll remember your tip about a
quick route to the temp folder next time.

"Dave Peterson" wrote:

Try closing excel and cleaning up your windows temp folder--it might help and it
can't hurt.

windows start button|Run
%temp%
is a quick way to get there.

And here are a couple of sites that discuss slow performance. The first is by
Charles Williams and the second by David McRitchie:

http://www.decisionmodels.com
http://www.mvps.org/dmcritchie/excel/slowresp.htm

Marcel wrote:

I have a 198 Kb size Excel 2000 file that takes 3 1/2 minutes to open using
my new Dell computer. The file is not saved locally but to a server. It
opens fine in a much older computer.

There is an Excel 2000 file slightly larger than this one and more complex
with charts and links to other files and it opens in a couple of seconds on
the new Dell computer. This file is also saved on the server.

Can anyone explain why this is the case?

--

Dave Peterson


--

Dave Peterson


--

Dave Peterson