> > I'm gonna hope this comes in a lot lower on the priorities than some > functions I need to add. =P >
I hear that. When I first looked into it, I got very creative in finding ways to do what we needed without using Pivot Tables :) In the past, the only time I used them with POI was through a template built in Excel where the pivot referenced a full sheet of data, and I could update that sheet with however many rows of data the specific instance needed. It worked specifically because I didn't have to touch the pivot table structures at all. If your pivot table references an Excel structured table, those are also not as bad to manipulate, even changing the number of rows.
