Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
64k row limit | Excel Worksheet Functions | |||
the limit on how many rows can be in one spreadsheet | Excel Worksheet Functions | |||
How do I limit the number of complete sentences in a spreadsheet c | Excel Worksheet Functions | |||
How do I limit number of rows and columns on a spreadsheet | New Users to Excel | |||
Nested IF limit or Open parentheses limit | Excel Discussion (Misc queries) |