Slicer Connections - Excel 2010

[Terence Mervis]

Hi,
Excel 2010 - I can't connect multiple pivot tables to a common slicer. The Pivot Table Connection dialogue box shows only the first pivot table. The Slicer Connector doesn't show anything in the dialogue box. All the pivot tables are on the name worksheet and are all connected to the same source data. Could it be because I created separate PT Cache's for each Pivot Table? How do i get around this problem? Also, another problem i have is once I've copied my PT into the DashBoard, it no longer connects to the PT Cache?
Many Thanks

 

[bobhc]

All pivot tables have their own cache of data from which the PT pulls data to work with you cannot have one slicer pulling from different cache, to do as you want you create multiple pivot tables from the same pivot cache, you can connect them to the same slicers, and filter all the pivot tables at the same time.


http://blog.contextures.com/wp-content/uploads/2011/03/video62e45985534c.jpg

.