ExcelBanter - Excel crashes

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - Excel crashes (https://www.excelbanter.com/setting-up-configuration-excel/237618-excel-crashes.html)

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

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

On Tue, 21 Jul 2009 14:44:02 -0700, bigfile
wrote:

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

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

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