How to apply One pivot table filter to other Pivot table Automatically

Question

I have 3 Pivot tables in a worksheet "Sheet3" and with names Pivot1, Pivot2, Pivot3 respectively. All the three pivot tables have same fields but only difference is the structure.

I'm trying to apply one filter which is applied in Pivot1 to Pivot2, Pivot3 without calling a macro manually. Which means, once I applied the "Date" filter in Pivot1 I want the same filter to be applied for Pivot2, Pivot3.

Is it possible to apply filters to one pivot table through a macro which will be triggered automatically when one filter is changed in a pivot table? Any help is appreciated. A sample macro will be great for me. I tried the solution for the same problem given here: How can I make multiple pivot tables mimic the filters (report and row label) of another on just that sheet in excel? but I neither understood the code nor the code is updating the pivot tables.

Answer 1

If you have Excel 2010 or later, just insert a Slicer for the field of interest, and then connect that Slicer to the other PivotTables by right-clicking on it, selecting 'Report Connections' from the right-click menu, then selecting the checkboxes of the other PivotTables you want to control. This assumes all PivotTables are based on the same data source.