Connecting your slicer to all your pivot tables could be interesting when you create a complex dashboard with many pivot tables.
Add Slicers in Excel
Slicers in Excel provide an easy way to filter data in pivot tables and charts. They offer a user-friendly interface with buttons for selecting data. But how to add them. In fact there are 2 ways.
- From the ribbon PivotTable analysis > Insert Slicer
- Or, with a right-click on the field name. For years, it was the only way to add a slicer with Excel Online.
In both techniques, the process begins with the selection of a single pivot table. Consequently, the slicer will be connected exclusively to the chosen pivot table ☹️. Have a look at the following situation. When you select a Country in the slicer, only the data of the right table are filtered.
Connect Multiple Pivot Tables to a slicer.
In our situation, to connect the Country slicer to both Pivot Tables, here are the steps
- Select the slicer you want to connect
- Go to the "Slicer" tab on the ribbon.
- Click "Report Connections." An alternative is to right-click on the slicer to select the same option.
- A dialog box appears showing all pivot tables in the workbook.
- Check the boxes next to the name you want the slicer to control. In our example, we will select the 2 Pivot Tables
- Click "OK"
That's all there is to it! Now, selecting a country code from the slicer will filter both Pivot Tables according to this value.
Related Articles
You can find more information about the way to use the slicers in Excel in the following articles.