Terence Mervis
New Member
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
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