PivotField.ClearManualFilter Method
| Excel Developer Reference |
Provides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList and VisibleItemsList collections in OLAP PivotTables.
Version Information
Version Added: Excel 2007
Syntax
expression.ClearManualFilter
expression A variable that represents a PivotField object.
Remarks
This method is available for the PivotField object in PivotTables and for the CubeField object in the OLAP PivotTables. Calling it for a PivotField in an OLAP PivotTable will return a run-time error.
After calling this method, the following collections are empty: HiddenItemsList, HiddenItems, VisibleItemsList, and VisibleItems.
See Also