Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotField.EnableMultiplePageItems Property

Office 2007
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 2007

Syntax

expression.EnableMultiplePageItems

expression   A variable that represents a PivotField object.

Remarks

The existing property value is retained for OLAP.

Bb213325.vs_note(en-us,office.12).gif  Note
In Excel 2007, 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.



Community Additions

Show: