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