Excel macro: linking multiple pivot tables to same value

Question

Hello,

I have an excel workbook with multiple pivot tables--each with the same filter.  I would like to change all pivot table filters simultaneously.  For example, when pivot table 1 is filtered to A, I would like pivot tables 2 through 5 to also be filtered to A.  Is there any way to link the filters of the pivot table to one location so that I don't have to manually toggle the fitler in every single pivot table routinely?

Thanks very much for your help.

Answer 1

Hi,

Yes, for slicers to cut across Pivot Tables, all Pivot Tables should be created from the same source data range.

Answer 2

Hey Ashish

All the pivot tables should be of the same data source? is it necessary?

Answer 3

Thank you.  Unfortunately, I only have excel 2007.  Could this perhaps be accomplished with a macro--and a button in the excel workbook linking to the macro?

Answer 4

Hi,

In Excel 2010 and higher versions, this can be accomplished with using Slicers.  Slicers across multiple Pivot tables can be linked such that a filter selection on one slicer applies to all Linked slicers.