Slicer Connection to Multiple Pivot

[Aaditya Hamine]

Hello all Experts out there,

Merry Xmas to all !

My query is regarding slicer connections to multiple pivot tables.

I have 5 Pivot Tables in an excel file and my slicer is showing only 2 pivot tables under connections .

can anyone help me on how to connect all the 5 pivot tables to a single slicer.

All the 5 pivot tables are having single format of data -

Thanks,
Aaditya

 

[chirayu]

refer to below link

https://contexturesblog.com/archive...ultiple-pivot-tables-with-excel-2010-slicers/

 

[Aaditya Hamine]

Dear Chirayu,

thanks for the reply . I tried that particular link already - but it is not allowing to select more than 2 pivot tables.

 

[GraH - Guido]

Then you have multiple pivot cache... You can only share slicers between pivots if they share the same cache.