Share via


CubeField.ClearManualFilter Method

Excel Developer Reference

The ClearManualFilter method provides an easy way to set the Visible property to True for all items of a PivotField in PivotTables, and to empty the HiddenItemsList/VisibleItemsList collections in OLAP PivotTables.

Version Information
 Version Added:  Excel 2007

Syntax

expression.ClearManualFilter

expression   A variable that represents a CubeField object.

Remarks

This method is available for the PivotField object in PivotTables and for the CubeField object in the OLAP PivotTable. Calling it for a PivotField in an OLAP PivotTable will return a run-time error.

After calling this method, the HiddenItemsList/HiddenItems and VisibleItemsList/VisibleItems collections are empty.

See Also