Files tool long to open

[Jay]

I have an excel file (about 8MB) and it takes a long time
to open and close (even without saving). I know that it
has a lot of sheets, macros and formulae but here is the
funny thing. The predecessor to this file (the new file is
an offshoot of this one) is much larger in size (13MB) and
includes more formulae and sheet and it opens and closes
much faster than the smaller file.

What exactly determines how long a file takes? How can I
make this new file (8MB) open and close much faster,
especially when I am not even saving it?

Thanks,
Jay

 

[Dave Peterson]

Cleaning the windows temp folder sometimes works wonders.

You may want to take a look at these two sites
(Charles Williams and David McRitchie):

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