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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Exceed Row Limit 4
Max function for row with named cells 3
Display row of the maximum in a list 2
max query result size 3
Using VLOOKUP inside SUMPRODUCT => complex problem 3
"Maximum Number of fonts exceeded" 2
Auto fit and text wrapping problem 1
Deleting Row 1

Top