View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.setup
BobD
 
Posts: n/a
Default Excel - should handle UNLIMITED records like QuatroPro!

David,
It's a pet peeve. There are places in the scientific community where a
million rows still doesn't cut it. There are many datasets in the oil and
gas industry that routinely exceed this restriction.

What programmers and casual users don't realize is that operations within a
row can be accomplished quite easily within Access , but mathematical
operations between rows or a series of rows is more efficient in Excel. The
export problem with more than two decimal places is a real fiasco when trying
to export a 6 place Latitude-Longitude in decimal degrees.

Thanks for the feedback.
Bob

"David McRitchie" wrote:

Hi Bob,
The row limit is fixed in Excel 12 (rows not records)
http://blogs.msdn.com/excel/archive/...26/474258.aspx

The total number of available rows in Excel
Old Limit: 64k (2^16)
New Limit: 1M (2^20) -- which is 1,048,576 rows

For a list of posting by Microsoft employees see
http://www.contextures.com/xlExcel12Info01.html

If you have something you want fixed you probably have to wait for Excel 12 to
come out and then put your request in withing two weeks if you want to see it
happen within the next 10 years after that.

Or as IBM would might reply -- fixed in the next version, if there is a next version.
At least you know there will be an Excel 12.