Excel should handle more than 65,536 rows.

G

Guest

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/com...c-343a81316af7&dg=microsoft.public.excel.misc
 
D

Dave Patrick

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

:
| 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/com...c-343a81316af7&dg=microsoft.public.excel.misc
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Increase worksheet size to more than 65,536 rows 2
EXCEL FUNCTIONS 1
MS Excel should handle dates before 1900! 3
How do a import data from a text file to an excel worksheet 4
interpreter .csv files (when opening .csv) should be configurable 2
Excel should let me create pivot tables of non-numeric data. 2
distinct count summarize Data for pivoit table 1
please, add the feature that allows us to attach file with our thr 3

Top