The 65,000 record limit in Excel is archaic. Works fine for business, but
the scientific community is shackled with this 1980's artifact from 640K DOS
memory constraint. While the programmers are at it, fix the bug in Access
that only exports 65,000 records with a fixed 2 decimal place number.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/comm...ic.excel.setup

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.

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.