Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
Posted to microsoft.public.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 |
#5
Posted to microsoft.public.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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how can i increase number of rows beyone 65536 in excel sheet | Excel Discussion (Misc queries) | |||
Isolate rows based on highlight (Excel 2003) | Excel Worksheet Functions | |||
How do I import data into Excel that exceeds 70000 rows? | Excel Discussion (Misc queries) | |||
Keep rows on same page in Excel | Excel Discussion (Misc queries) | |||
How do I remove blank rows in Excel? | Excel Discussion (Misc queries) |