Spreadsheet Limit
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
"Dennis1188" wrote:
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?
|