Question

AlexMartini on Tue, 25 Oct 2016 22:32:18


Hallo. How can I create a slicer for all the pivot tables on a sheet. 

Sponsored



Replies

Angelia Zhang on Wed, 26 Oct 2016 10:12:48


Hi AlexMartini,

The prerequisite to create a slicer for all the pivot tables on a sheet is all the pivot tables from same table resource. If 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 according to following steps.

For excel 2010, Select any cell in the pivot table. On the Options tab of the Ribbon, click Insert Slicer. Check the fields for which you want to add slicers, then click OK.

   1.Select a cell in the second pivot table
   2.On the Excel Ribbon’s Options tab, click Insert Slicer
   3. Click Slicer Connections

For Excel 2013, 2016 version. Click Insert dialog->Slicer. Right click and select Report Connection, it return below window, please select the all pivot tables and click “OK”.



Best Regards,
Angelia