Connect slicer to multiple Pivot Tables

Last Updated on 30/10/2024
Reading time: 2 minutes

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.

Only one slicer connected to the pivot table

Connect Multiple Pivot Tables to a slicer.

In our situation, to connect the Country slicer to both Pivot Tables, here are the steps

  1. Select the slicer you want to connect
  2. Go to the "Slicer" tab on the ribbon.
  3. Click "Report Connections." An alternative is to right-click on the slicer to select the same option.
  4. A dialog box appears showing all pivot tables in the workbook.
Dialog box to connect a slicer to many pivot tables
  1. Check the boxes next to the name you want the slicer to control. In our example, we will select the 2 Pivot Tables
  2. 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.

All pivot table connected to one slicer

You can find more information about the way to use the slicers in Excel in the following articles.

Leave a Reply

Your email address will not be published. Required fields are marked *

Connect slicer to multiple Pivot Tables

Reading time: 2 minutes
Last Updated on 30/10/2024

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.

Only one slicer connected to the pivot table

Connect Multiple Pivot Tables to a slicer.

In our situation, to connect the Country slicer to both Pivot Tables, here are the steps

  1. Select the slicer you want to connect
  2. Go to the "Slicer" tab on the ribbon.
  3. Click "Report Connections." An alternative is to right-click on the slicer to select the same option.
  4. A dialog box appears showing all pivot tables in the workbook.
Dialog box to connect a slicer to many pivot tables
  1. Check the boxes next to the name you want the slicer to control. In our example, we will select the 2 Pivot Tables
  2. 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.

All pivot table connected to one slicer

You can find more information about the way to use the slicers in Excel in the following articles.

Leave a Reply

Your email address will not be published. Required fields are marked *