Excel maximum Row number

X

xiaoniao

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 ?
 
S

Stefi

Use Excel 2007, it has one million rows.
Regards,
Stefi


„xiaoniao†ezt írta:
 
R

ryguy7272

If you can work exclusively in a Pivot Table you won't be subjected to that
65,535-row-limit-issue.

Regards,
Ryan--
 
Top