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