Good to know. I can enforce a certain discipline on the users like "You must use a table", so there's that.
On Wed, Mar 21, 2018 at 3:45 PM, Greg Woolsey <greg.wool...@gmail.com> wrote: > > > > 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. > -- *Blake Watson* *PNMAC* Application Development Manager 5898 Condor Drive Moorpark, CA 93021 (805) 330.4911 x7742 blake.wat...@pnmac.com www.PennyMacUSA.com <http://www.pennymacusa.com/>
