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?