PivotField.EnableMultiplePageItems property (Excel)

Used for specifying whether check boxes are present in the filter drop-down list for fields in the page area. Read/write Boolean.

Syntax

expression.EnableMultiplePageItems

expression A variable that represents a PivotField object.

Remarks

The existing property value is retained for OLAP.

Note

In Excel 2007 or later, if you create pre-Excel 2007 OLAP PivotTables (PivotTable.Version < 3) with the SubtotalHiddenPageItems property of the PivotTable object and the EnableMultiplePageItems property of the PivotField object set to True, changing the state of the check boxes in the filter drop-down menu of the page area will have no effect. In this case, the filter will always be set to All, including the unchecked (hidden) items.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.