Excel crashes

B

bigfile

Have I exceeded the size limits for Excel? Filesize 15M and appl.
hangs/crashes.
Any hint how to handle big files?
 
G

Gord Dibben

Excel can crash from many different reasons.

Size is only one of those.

15MB would not be considered inordinately large depending upon resources
available to you.

See Charles Williams site for calculation problems.

http://www.decisionmodels.com/


Gord Dibben MS Excel MVP
 
S

Simon Murphy

15Mb and beyond is fairly normal size wise.
Well written spreadsheets can still work well at 2-300Mb in size on a
standard corporate workstation.

The big advice would be to work locally on your C: drive if possible and
copy to the network as a separate activity. Opening big files over the
network can be painful in Excel.

Your crashes are more likely caused by add-ins or file corruption than
pure size/complexity.

Cheers
Simon
Excel development website: www.codematic.net
 

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

Top