Maxumum No of Rows in Excel

[Guest]

I had read a couple of months ago that the new Excel 2007 can have up to 1
million rows. Microsoft's web site still says that. We just purchased an
upgrade to 2007 for that feature alone. We deal with large amounts of
precipitation and flow data. After bringing inour data, it looks like they
are still limited to 65,500. Am I missing something, or is Microsoft just
making things up to trick people into upgrading?

 

[Gord Dibben]

If your workbook is an xls workbook, then only 65,536 rows show. Save as an
xlsx and it will have the million rows.


Gord Dibben MS Excel MVP

 

[Guest]

Hi,

Just click on an "empty cell" and then press CTRL+Down arrow, you will know
the last row of the excel sheet. For examaple, it will show you 65536 in
2003.

Challa Prabhu

 

[Guest]

Hi, I think that I found the problem. If you start with an old spreadsheet
and save it in the new format file *.xlsx you still don't get more than 65536
rows. But, if you start with a completly new worksheet and save it as a
*.xlsx and then copy in the data, then you get the full number of rows.
Apparently if you start with an old format worksheet you get locked into the
old limitation, even if you save it as the new format.

 

[RobN]

I believe you may not have converted your workbook correctly. If you simply
save to the new format, you do seem to retain the number of rows, but if you
Convert you end up with the million or so rows.

The Convert function appears when you open an older version Excel file when
you click the top left round icon.

Rob


If I convert an old workbook to the new xlsm format, I get all the rows