I gave this a try and it doesn't seem to work. Perhaps I'm doing something incorrectly. I have three .xls sheets within my workbook:
1. Has a "Summary" pivot table.
2. Has another pivot table based on the summary pivot table named "Historical".
3. Contains a flat file I've exported from Oracle 11i, named "Data", for which the summary pivot table is based on.
What I would like to do is to excluded certain rows from the "Summary" pivot table and as I do this I would like the second "Historical" table to reflect those changes. I think you have the answer but I'm implementing it incorrectly. Can you advise based on the above please? Thanks