Hi there,
I have many workbooks that each contain many pivot table reports ..often as many as 20 or 30 in a workbook. Most are reports for diffent people with different needs, but all reading from the same underlying data.
Frequently there is a need for an additional field to be added to help the pivot tables zero in on selected conditions.
The problem is if a field is added at the end of the others, it seems one has to go into each pivot table individually and redefine the source data in each. I realize if I 'insert' a new field in the source data the pivots will include that, but that doesn't work because often the source data is 'downloaded' from other mainframe files and the new column needed at the end is based on a formula or lookup.
Any way around having to do each one independently?
Thanks
Bookmarks