 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Setup / May 2006Excel 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. Sounds to me that you should do the report in Access, or summarise the data before downloading the data.  SignatureHTH 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 [quoted text clipped - 7 lines] > 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/community/en-us/default.mspx?mid=b0463c7e-1471-4 bc7-8d61-1023aa10067c&dg=microsoft.public.excel.setup I aggree with bob. FSt1 > 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 [quoted text clipped - 9 lines] > > http://www.microsoft.com/office/community/en-us/default.mspx?mid=b0463c7e-1471-4 bc7-8d61-1023aa10067c&dg=microsoft.public.excel.setup 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. > 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 [quoted text clipped - 9 lines] > > http://www.microsoft.com/office/community/en-us/default.mspx?mid=b0463c7e-1471-4 bc7-8d61-1023aa10067c&dg=microsoft.public.excel.setup 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 to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.