PivotField.EnableMultiplePageItems Property
Used for specifying whether or not check boxes are present in the filter drop-down list for fields in the page area. Read/write Boolean.
Version Information
Version Added: Excel
Syntax
expression.EnableMultiplePageItems
expression A variable that represents a PivotField object.
Remarks
The existing property value is retained for OLAP.
 Note
|
|---|
| In Excel, if you create pre-Excel 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. |