Excel limitations

[Tigerxxx]

Is there a limitation to Excel to perform well or become corrupt in terms of:

Size of the file
Columns & rows used in teh file
Number of worksheets used in the file
Any other limitations.

Thank you

 

[Bruce Sinclair]

Is there a limitation to Excel to perform well or become corrupt in terms of:

Size of the file
Columns & rows used in teh file
Number of worksheets used in the file
Any other limitations.

Not sure about 2007, but in earlier version, lots of charts will clog it up
nicely. Many problems with saving (particularly) can be fixed by deleteing
a few charts.

 

[Bob I]

See Help, look up "Limits", Click "Excel specifications and limits",
then read each of the sub links.

 

[Gord Dibben]

Go to Charles Williams' site and browse through the Excel Pages on optimizing,
calc secrets, memory etc.

http://www.decisionmodels.com/


Gord Dibben MS Excel MVP