Excel should handle more than 65,536 rows.
 

We deal with large amounts of data and the current row limit of 65,536
repeatedly hinders us. This has been the limit for a long time and I don't
understand why it hasn't been increased or eliminated. With today's
computers it seems Excel should be able to handle much more. At the very
least make it an overall number of cells limit, not an X by Y limit.

----------------
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...lic.excel.misc

Excel is not meant to be a data store. You really should be using Access or
SQL server for your data store.

--
Regards,

Dave Patrick ....Please no email replies - reply in newsgroup.
Microsoft Certified Professional
Microsoft MVP [Windows]
http://www.microsoft.com/protect

"colekp" wrote:
| We deal with large amounts of data and the current row limit of 65,536
| repeatedly hinders us. This has been the limit for a long time and I
don't
| understand why it hasn't been increased or eliminated. With today's
| computers it seems Excel should be able to handle much more. At the very
| least make it an overall number of cells limit, not an X by Y limit.
|
| ----------------
| 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...lic.excel.misc

http://blogs.msdn.com/excel/default.aspx
The Excel 12 grid will be 1,048,576 rows by 16,384 columns.

HTH,
Bernie
MS Excel MVP


"colekp" wrote in message
...
We deal with large amounts of data and the current row limit of 65,536
repeatedly hinders us. This has been the limit for a long time and I don't
understand why it hasn't been increased or eliminated. With today's
computers it seems Excel should be able to handle much more. At the very
least make it an overall number of cells limit, not an X by Y limit.

----------------
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...lic.excel.misc