Excel file opens slowly

G

Guest

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?
 
G

Guest

Thanks for the quick reply. However, I made a copy of the file to the local
drive and I get the same results. The OS on the Dell is XP Pro and uses EZ
antivirus software from e-trust.
 
G

Guest

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.
 
D

Dave Peterson

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
 
G

Guest

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.
 
D

Dave Peterson

I don't have a real guess.

Can you rebuild that workbook and see if that helps?
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.
Click to expand...
 
G

Guest

I guess I can give it a try. There are 25 worksheets, but all with similar
formats and formulas. Only the data is different.

I'll give it a try and see if that works.
 
G

Guest

Okay, I finally finished rebuilding the whole workbook. I was able to reduce
the size to 170 Kb. But the file still takes about 1 minute to open.

I hope someone can help. Let me know if there is any other info I can
provide.

Thanks.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Spreadsheet opens very slowly 5
Excel saved files won't open, only the program opens 1
Excel opens book2 when opening a file 1
excel spreadsheets open slowly 1
File opens and saves slowly 2
Excel stopped working 3
failure to open up excel file 3
File Opens Very Slowly 1

Top