Excel should have 200,000 rows maximum

[Guest]

I am often assigned to create a report based on formatted reports downloaded
from a database. Excel's maximum number of rows is most of the time
insufficient to accomodate the data. I often times have to eliminate
unneccesary rows through Access prior to finalizing everything in Excel.

----------------
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...-1023aa10067c&dg=microsoft.public.excel.setup

 

[Bob Phillips]

Sounds to me that you should do the report in Access, or summarise the data
before downloading the data.

--

HTH

RP
(remove nothere from the email address if mailing direct)

I am often assigned to create a report based on formatted reports downloaded
from a database. Excel's maximum number of rows is most of the time
insufficient to accomodate the data. I often times have to eliminate
unneccesary rows through Access prior to finalizing everything in Excel.

----------------
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...-1023aa10067c&dg=microsoft.public.excel.setup

 

[Guest]

I aggree with bob.

FSt1

 

[Guest]

Why do you use excel for this task. why can't you use Access.
I suppose ths is another of the cases where one wants to use excel for
everything. Not many realise the diffrences of a spread sheet and a
relational data base.

 

[Pete_UK]

The next version of Excel (2007) will have the capability of up to 1
million rows, so you'll be able to use that when it finally gets
released.

Pete