CubeField.ClearManualFilter Method

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

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 HiddenItemsInList/VisibleItemsList collections in OLAP PivotTables.

public:
 void ClearManualFilter();

public void ClearManualFilter ();

Public Sub ClearManualFilter ()

Remarks

This method is available for the PivotFieldobject in PivotTablesand for the CubeFieldobject 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.