Linking one pivot table to another pivot table

[Laurenceosinsao]

Hi, Need your help. How can I link same pivot table to another? Like if I change the filter to the first table, the second table will automatically change after. Thank you!

[teylyn]

Hello,

with your Office version you can use slicers to filter pivot tables. Slicers can be connected to multiple pivot tables.

- Create a slicer for the first pivot table.
- Right-click the slicer and select "Report Connections".
- a dialog will show all pivot tables that have been created from the same pivot cache and you can select them to connect them to the slicer.

cheers, teylyn

[Laurenceosinsao]

Yes, It worked. Thank you!

[MarvinP]

Here is a link to show what teylyn is talking about. Slicers are new to 2010 Excel and newer versions.

http://blog.contextures.com/archives...-2010-slicers/

[Laurenceosinsao]

Thank you all for answering!