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

在Excel 2007和早期版本中，如果要同时自动筛选多个数据透视表，则可以使用Excel VBA代码。 得益于新的Slicer功能，该任务在Excel 2010中要容易得多。

切片器简介 (Slicer Intro)

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

我们在10月的万圣节恐怖电影的Excel切片器博客文章和切片器介绍视频中研究了切片器 。

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
  在Excel功能区的“选项”选项卡上，单击“插入切片器”
• 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, you can  watch one of these short videos.

要查看将多个数据透视表连接到切片器的步骤，可以观看以下简短视频之一。

• The first video shows the steps in Excel 2010
  第一个视频显示了Excel 2010中的步骤
• The second video shows the steps in Excel for Office 365.
  第二个视频显示了Office 365的Excel中的步骤。

Steps in Excel 2010

Excel 2010中的步骤

演示地址

Steps in Excel for Office 365

Excel for Office 365中的步骤

演示地址