ClearAllFilters 方法 (Excel)PivotField.ClearAllFilters method (Excel)

调用此方法将删除当前应用于透视字段的所有筛选。Calling this method deletes all filters currently applied to the PivotField. 这包括删除透视字段的**PivotFilters** 集合中的所有筛选器, 还会删除应用于透视字段的任何手动筛选。This includes deleting all filters from the PivotFilters collection of the PivotField and removing any manual filtering applied to the PivotField as well. 如果透视字段位于报表筛选区域中,则所选项将被设置为默认项。If the PivotField is in the Report Filter area, the item selected will be set to the default item.

语法Syntax

表达式ClearAllFiltersexpression.ClearAllFilters

_表达式_一个代表**透视字段** 对象的变量。expression A variable that represents a PivotField object.

支持和反馈Support and feedback

有关于 Office VBA 或本文档的疑问或反馈?Have questions or feedback about Office VBA or this documentation? 请参阅 Office VBA 支持和反馈,获取有关如何接收支持和提供反馈的指南。Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.