| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Total rows allowed on spreadsheet 2007 version
I have the 2007 upgrade for office and I am not able to go past 65,000 rows
in excel, however 2007 excel boasts over a million rows. Is there a setting somewhere I need to set to allow for more lines? -- Babyjsmom |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Total rows allowed on spreadsheet 2007 version
Only new workbooks created in 2007 will have 1,048,576 rows. Older workbooks
from 2003 or earlier will still have the 65,536 row limitation. Even if they are converted to 2007 format. HTH Elkar "Babyjsmom" wrote: I have the 2007 upgrade for office and I am not able to go past 65,000 rows in excel, however 2007 excel boasts over a million rows. Is there a setting somewhere I need to set to allow for more lines? -- Babyjsmom |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How can I get the same colors from 2003 version to 2007 version? | Excel Discussion (Misc queries) | |||
| Maximum number of variables allowed in an Excel Spreadsheet? | Excel Discussion (Misc queries) | |||
| How many lines are allowed in 2-D graph, Excel 2007 | Charts and Charting in Excel | |||
| What is the Max number of records/row allowed in Excel 2007 | Excel Discussion (Misc queries) | |||
| Format spreadsheet so no input allowed if certain cell is =<0 | Excel Worksheet Functions | |||
Linear Mode
