Hi Guys,

I have my data in sheet "P_Data". The whole data is in a table (Table1). All the pivot tables (9) in this workbook reference to the same data (table1).

Right now I'm manipulating the data through VBA to delete most of the data, except for one condition, then refreshing all the pivot tables and creating a new workbook based on that data.

The problem is that I dont know who to update the pivot cache for all the tables at ones, in that way there is no trace back to the original data source and the slicers get updated only with the filtered information.

Please adivise! Thanks