| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotField.ClearManualFilter method (Excel) |
vbaxl10.chm240153 |
|
|
6c8e1bae-4896-049e-070c-9c9a08c223ba |
05/04/2019 |
medium |
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.
expression.ClearManualFilter
expression A variable that represents a PivotField object.
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.
[!includeSupport and feedback]