Filter Multiple Pivot Tables With Excel 2010 Slicers

iconslicer In Excel 2007, and earlier versions, you can use Excel VBA code if you want to automatically filter several pivot tables at the same time. That task is much easier in Excel 2010, thanks to the new Slicer feature.

Slicer Intro

We took a look at slicers in October, in the Excel Slicers for Halloween Horror Films blog post and Slicer intro video.

To insert a slicer for a pivot table,

  • 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


The slicers appear on the worksheet, and you can resize them and move them. Then, click on the pivot items, to filter the pivot table.


Connect Another Pivot Table

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.

To create the Slicer connection in the second pivot table:

  • Select a cell in the second pivot table
  • On the Excel Ribbon's Options tab, click Insert Slicer
  • Click Slicer Connections


In the Slicer Connections window, add a check mark to each slicer.


Both pivot tables are now connected to the Slicer. If you select an item in a slicer, both pivot tables will be filtered. For example, in the Product slicer below, Paper is selected, and both pivot tables show only the Paper sales.


Watch the Connected Slicers Video

To see the steps for connecting multiple pivot tables to a slicer, please watch the short Connect Slicers to Multiple Excel 2010 Pivot Tables video below.

Watch  on YouTube: Connect Slicers to Multiple Excel 2010 Pivot Tables


You may also like...

21 Responses

  1. Dustin Cochran says:

    Can you make multiple selections with the slicers while controlling both PTs, i.e., selecting Paper AND Pens?

    I haven’t found any VBA examples that can do this (normally, it is all, OR just one page field selected).



  2. Luke Wisbey says:

    You can iterate the SlicerItems collection of the relevant SlicerCache (parent object being the workbook) and apply the relevant Boolean to Selected status of SlicerItem
    (clearmanualfilter prior to the iteration)

  3. James says:

    Does anyone know how to stop slicers moving around when you make selections. This happens if the slicers are viewed on top of the pivot table data. As the pivot output data shinks or expands the slicers move around and sometimes obscure each other.
    Any idea how to fix in place?

  4. james humphrey says:


    If I understand your question correctly… you can disable resizing and moving by right clicking to select the options and then click/check the “Disable resizing and moving” box.

    Hope this helps

  5. Charlie says:

    omg. I love you for this.
    this will save me N minutes every day

  6. Joseph says:

    On one tab in the Excel 2010 workbook I have all of my slicers, one slicer has all of my projects listed. On another tab in the workbook I want to have multiple Pivot tables, say 10 tables.

    My question is in the project list slicer can I use choose multiple projects and then have each project selected in the slicer fill in the 10 pivot tables in succession? I’m trying to create a roll-up of all my projects using slicers.

  7. Lori Watrous says:

    Can this work with PowerPivot? I have several pivot tables in one file built with same data tables. I would like to the filter on all of them at the same time.

  8. Allen Green says:

    I am creating an analysis tool that looks at multiple sources of information from the same system, This is then pulled down into excel via different reports due to the differing areas within the system e.g. purchase ledger, sales ledger and nominal ledger.

    This info is then customised via individual pivot tables

    within each different source lies the same basic criteria . . a code where the transaction has been posted, and a period in which the transaction has occurred

    can i use slicers to link this basic filtering criteria amongst my pivot tables?

  9. Jeff Weir says:

    @Allen…when you say “This is then pulled down into Excel via different reports” do you mean that data is pushed/pulled into separate tables within your spreadsheet, and then each pivot table points to one of these separate tables? If so, slicers won’t work. Slicers only work if pivots share the same cache. But if that’s the case, you can use the code at

  10. Katrena Parker says:

    Having a hard time with slicers. Created many different slicers from several pivot tables. Needed to change the data source and now it says I need to disconnected all of the slicers connected to the data source before I can update the Pivot Tables. I cannot find documentation anyway explaining how I can maintain the slicers and change the data source of the Pivot Tables.

    • Susan Mathison says:

      I’m having the same problem. Have to disconnect the slicers and then update pivot data source. Seems non-intuitive to being a ‘connected’ slicer.

  11. Tiffany says:

    I’ve created a pivot table and added slicers by month. Why do I have an duplicate month in the same slicer?

  12. Ezgi says:

    Hi, I wonder if I have 3 different pivot tables which get data from 3 different data set, is it possible to connect them as well. Those pivot tables have the same format and same filter. The only thing their resources are different sheets?


  13. Ajay Lad says:

    is there a way you can refresh a pivot table when selecting a slicer

  14. Wobie says:

    how can I automatically select all Pivot Tables to connect to slicer in just one (1) click.
    to picture this out….pls check the Slicer Connections (Pivot Table 3) as shown in the above of this site.

    You see there is no way of clicking all items inside a slicer in just one (1) click. You must have to do it manually. What if I have too many pivot tables that I want to connect with or make it slave???

    Please help. Thank you

  1. November 29, 2012

    […] experimented with drop down lists and slicers, and finally settled on a good old-fashioned scroll bar. You can click or drag the scroll bar to […]

  2. December 13, 2012

    […] Dalgleish, on December 13th, 2012 Slicers were introduced in Excel 2010, and they make it easy to change multiple pivot tables with a single click. In earlier versions, you can use programming to change the report filters in […]

  3. February 28, 2013

    […] Yes, you can use Slicer Connections: Filter Multiple Pivot Tables With Excel 2010 Slicers | Contextures Blog […]

  4. May 23, 2013

    […] to the Board! See: Filter Multiple Pivot Tables With Excel 2010 Slicers | Contextures Blog […]

Leave a Reply

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