Excel should have 200,000 rows maximum
 

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/comm...ic.excel.setup

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)


"nl" wrote in message
...
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/comm...ic.excel.setup

I aggree with bob.

FSt1

"nl" wrote:

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/comm...ic.excel.setup

Excel should have 200,000 rows maximum
 

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.

"nl" wrote:

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/comm...ic.excel.setup

Excel should have 200,000 rows maximum
 

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