Spreadsheet Limit
 

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?

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?

Spreadsheet Limit
 

XL 07 does NOT allow 65,000+ columns. Only 16,000 or so.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Jerry W. Lewis" wrote:

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?

Spreadsheet Limit
 

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

"Dave F" wrote:

XL 07 does NOT allow 65,000+ columns. Only 16,000 or so.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Jerry W. Lewis" wrote:

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?