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 ?

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 ?

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 ?