Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
More than 65K+ Rows
I have a data set that is appended to the end of a worksheet on a monthly
basis. This data set is then used as the source for a pivot table within the same workbook. The data set was started has been increasing since 1/2005 (comparing mothly data for year-to-year analysis) and has now reached the row limitation in Excel 2002 (last set was for 5/2006). To get around the 65,536 row limitation in Excel, I was thinking of breaking up the data onto a separate worksheet and 'expanding' the pivot table data range to include the new worksheet. I tried (ok, maybe not that hard) but could not modify the pivot table data range to include the new worksheet as part of the range. Is this possible? (or am I being too sneaky?) This process is not at all programatic, but manual (and I guess it will continue to be this way). I'm waiting for Excel 2007 (with 1M+ rows), but I hear it is still in Beta. I was also thinking of porting the data into an Access db, but because the data has to be editable/modifiable in numerous ways and iterations (and quickly), I want to keep it in Excel. But if there is no way around it, then I'm more than happy to use Access (no record limitations). Thanks in advance for any help anyone can provide. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
More than 65K+ Rows
Hi
Pivot tables made from multiple ranges are less userfriendly and flexible, so I believe you are better off with an Access data table and some clever way of editing the data in it. HTH. Best wishes Harald "ReportSmith" skrev i melding ... I have a data set that is appended to the end of a worksheet on a monthly basis. This data set is then used as the source for a pivot table within the same workbook. The data set was started has been increasing since 1/2005 (comparing mothly data for year-to-year analysis) and has now reached the row limitation in Excel 2002 (last set was for 5/2006). To get around the 65,536 row limitation in Excel, I was thinking of breaking up the data onto a separate worksheet and 'expanding' the pivot table data range to include the new worksheet. I tried (ok, maybe not that hard) but could not modify the pivot table data range to include the new worksheet as part of the range. Is this possible? (or am I being too sneaky?) This process is not at all programatic, but manual (and I guess it will continue to be this way). I'm waiting for Excel 2007 (with 1M+ rows), but I hear it is still in Beta. I was also thinking of porting the data into an Access db, but because the data has to be editable/modifiable in numerous ways and iterations (and quickly), I want to keep it in Excel. But if there is no way around it, then I'm more than happy to use Access (no record limitations). Thanks in advance for any help anyone can provide. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rows & Columns in Excel | Excel Worksheet Functions | |||
Automatically inserting rows | Excel Worksheet Functions | |||
Hiding Rows if the linked rows are blank | Excel Discussion (Misc queries) | |||
Insert rows | Excel Worksheet Functions | |||
flexible paste rows function that inserts the right number of rows | Excel Discussion (Misc queries) |