| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel maximum Row number
Why excel worksheet limit the row number to maximum 65536 only ? From my
calculation report, I really need to run the calculation to more than 65536 row, otherwise, I have to separate into two calculation with all the worksheet function. This is really tidious for me to sort out all the result. Is there any other way to extend the maximum row tange ? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel maximum Row number
Use Excel 2007, it has one million rows.
Regards, Stefi €˛xiaoniao€¯ ezt Ć*rta: Why excel worksheet limit the row number to maximum 65536 only ? From my calculation report, I really need to run the calculation to more than 65536 row, otherwise, I have to separate into two calculation with all the worksheet function. This is really tidious for me to sort out all the result. Is there any other way to extend the maximum row tange ? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Excel maximum Row number
If you can work exclusively in a Pivot Table you won't be subjected to that
65,535-row-limit-issue. Regards, Ryan-- -- RyGuy "Stefi" wrote: Use Excel 2007, it has one million rows. Regards, Stefi €˛xiaoniao€¯ ezt Ć*rta: Why excel worksheet limit the row number to maximum 65536 only ? From my calculation report, I really need to run the calculation to more than 65536 row, otherwise, I have to separate into two calculation with all the worksheet function. This is really tidious for me to sort out all the result. Is there any other way to extend the maximum row tange ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Maximum number of variables allowed in an Excel Spreadsheet? | Excel Discussion (Misc queries) | |||
| maximum number of rows in Excel 2007 | Excel Discussion (Misc queries) | |||
| Maximum number of data series possible in excel 2007 | Charts and Charting in Excel | |||
| What is the maximum number of rows in an Excel spreadsheet ? | Excel Discussion (Misc queries) | |||
| What is the maximum number of users that can share Excel File? | Excel Discussion (Misc queries) | |||
Hybrid Mode
