Multiple pivot tables controlled with one drop down

[Excelwig]

Hi

I’m working with aome data made a long time ago by someone else, there is a page using 5 seperate pivot tables and each one has a drop down to change the month it’s using.

Does anyone know a way where we can have one drop down that will update the 5 pivot tables to save doing each one ?

 

[RoryA]

Do the pivot tables use the same source data? If not, you'll need code to do it like this: https://contexturesblog.com/archives/2012/01/03/change-all-pivot-tables-with-one-selection/

 

[Excelwig]

Yes all 5 are reading from the one sheet with all the data on

 

[RoryA]

In that case, as long as you have a version of Excel that is 2010 or later, you can just add a Slicer and connect it to all the pivot tables.

 

[Excelwig]

Excellent thank you I will try that