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.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property EnableMultiplePageItems As Boolean
Get
Set
'Usage
Dim instance As PivotField
Dim value As Boolean
value = instance.EnableMultiplePageItems
instance.EnableMultiplePageItems = value
bool EnableMultiplePageItems { get; set; }
Property Value
Type: System.Boolean
Boolean
Remarks
The existing property value is retained for OLAP.
Note
In short_Excel2007, if you create pre-short_Excel2007 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.