More than 65K+ Rows

[Guest]

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.

 

[Harald Staff]

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