Spreadsheet Limit

D

Dennis1188

I have a 3000 line spreadsheet with 10 columns.
Each cell in each column has a formula in it.
I would like to add 10 more column also with formulas.
Is there a limit to what excel can handle?
 
J

Jerry W. Lewis

It depends on what version of Excel. See Help for "Microsoft Excel
specifications"

Excel 2007 permits up to 2^16=65536 columns and 2^20=1048576 rows
Excel 97 through 2004 permit up to 2^8=256 columns and 2^16=65536 rows
earlier Excel versions permit up to 2^8=256 columns and 2^14=16384 rows

Beyond these hardcoded limits, size is limited by available memory on your
computer.

Jerry
 
J

Jerry W. Lewis

Specifically 2^14=16384 columns.

Sorry, I didn't have access to 2007 at the time, but I did know that it was
a prior row limit. I just mis-remembered which prior row limit.

Good catch,
Jerry
 
Top