| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
CubeField.ClearManualFilter method (Excel) |
vbaxl10.chm668098 |
|
|
2dac2695-ae2c-eba9-7b22-57f21d87925a |
04/23/2019 |
medium |
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.
expression.ClearManualFilter
expression A variable that represents a CubeField object.
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.
[!includeSupport and feedback]