Pivot Table Link Help

[Andyaf]

Hi,

I’m trying to link multiple pivot tables to one filter. On the file attached, three pivot tables (second tab) are filtered based on Company and Unit. If possible, I’d like to link all filters to the first filter (i.e. if I select Company Rocky and Unit 1, the other two pivot table will automatically set these filters).

Does anyone know how this can be done?

Also, If I add additional information to a data set that is linked to a pivot table, will it automatically be updated?

Thanks for the help!

-Andy

 

[Debraj]

What excel version you are using..!!!

In case of 2010 + you can use Slicer..

Check this one..

 

[NARAYANK991]

Hi Andy ,

In case you are still with pre-2010 versions of Excel , you will have to use VBA ; see this link :

http://blog.contextures.com/archives/2012/01/03/change-all-pivot-tables-with-one-selection/

Narayan