PivotField.EnableMultiplePageItems Property

Reference

Definition

Namespace:: Microsoft.Office.Interop.Excel

Assembly:: Microsoft.Office.Interop.Excel.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Used for specifying whether or not check boxes are present in the filter drop-down list for fields in the page area. Read/write.

public:
 property bool EnableMultiplePageItems { bool get(); void set(bool value); };

public bool EnableMultiplePageItems { get; set; }

Public Property EnableMultiplePageItems As Boolean

Property Value

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.

Applies to