slicer connection doesnt show all the pivotables

[beneizmann]

hi
in my sheet, I have some pivotables which exact common source data
but when I create slicer connection I see just the current pivottable.
please, how can I fix it?

(I ensured it's same source data, I built the slicer again, I tried built slicer to each pivottable and after try connect them)

thanks
Ben

 

[andybrown115]

Hi Ben

If I'm understanding you correctly, you want to connect a single slicer to multiple pivot tables?

If that's correct, simply create your slicer as usual then right click on it (or use the top menu in "Slicer Tools > Options >". The select "Report Connections"

You should then be provided with a list of available pivot tables. Check each one you need to link to and click OK. Your slicer should then link to - and affect - each pivot table.