| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotField.EnableMultiplePageItems property (Excel) |
vbaxl10.chm240151 |
|
|
989fa662-cafb-00a1-effb-4a6c18327ea3 |
05/04/2019 |
medium |
Used for specifying whether check boxes are present in the filter drop-down list for fields in the page area. Read/write Boolean.
expression.EnableMultiplePageItems
expression A variable that represents a PivotField object.
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.
[!includeSupport and feedback]