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?

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


On Fri, 27 Apr 2007 13:46:01 -0700, Hydrology
wrote:

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?

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

"Hydrology" wrote:

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?

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.


"challa prabhu" wrote:

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

"Hydrology" wrote:

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?

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
"Hydrology" wrote in message
...
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.


"challa prabhu" wrote:

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

"Hydrology" wrote:

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?