vba自动筛选数据透视表
In Excel 2010, you can use Slicers to change multiple pivot tables. However, you might be working in an earlier version of Excel, or you don't have room for Slicers on your worksheets.
在Excel 2010中,可以使用切片器更改多个数据透视表。 但是,您可能正在使用早期版本的Excel,或者您的工作表上没有足够的切片器空间。
Instead of Slicers, you can use programming to update multiple pivot tables automatically. In previous posts, I've shown how you can select items in one pivot table's Report Filter fields, and the Report Filter fields for pivot tables on the other worksheets will change to the same selections.
代替切片器,您可以使用编程来自动更新多个数据透视表 。 在以前的文章中,我展示了如何在一个数据透视表的“报表过滤器”字段中选择项目,其他工作表上的数据透视表的“报表过滤器”字段将变为相同的选择。