If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#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
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Not Enough Rows in Excel | Joe_G | General Discussion | 6 | September 23rd, 2005 04:16 PM |
What is the maximum number of rows in an Excel spreadsheet ? | Larry Liu | General Discussion | 5 | September 20th, 2005 06:06 PM |
How do I import data into Excel that exceeds 70000 rows? | Claudia Phelps | General Discussion | 2 | March 25th, 2005 11:33 PM |
How to count number of rows in Excel? | Paul | Using Forms | 4 | March 8th, 2005 04:41 PM |
Windows in Taskbar | Chevy | General Discussion | 8 | October 15th, 2004 03:57 PM |