File takes long time to open

J

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
 
P

Polly

It could be to do with how many Add Ins you have.
Go to "Tools, AddIns", and check that the ones ticked are ones that yo
use. If you're not using them, untick, and it will help excel to star
faster
 

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

Files tool long to open 1
Why does it take so long to open? 7
File takes too long to open 1
long time to close spreadsheet 1
From share drive particular excel file takes long time to open 0
Takes too long for Filedialog to change directory 1
Save takes long time 2
Saving a file takes very long 1

Top