PivotField.EnableMultiplePageItems Property

  • Article
Excel Developer Reference

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.

See Also