Partager via


PivotTable.ShowPageMultipleItemLabel Property

When set to True (default), "(Multiple Items)" will appear in the PivotTable cell on the worksheet whenever items are hidden and an aggregate of non-hidden items is shown in the PivotTable view. Read/write Boolean.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property ShowPageMultipleItemLabel As Boolean
    Get
    Set
'Usage
Dim instance As PivotTable
Dim value As Boolean

value = instance.ShowPageMultipleItemLabel

instance.ShowPageMultipleItemLabel = value
bool ShowPageMultipleItemLabel { get; set; }

Property Value

Type: System.Boolean

See Also

Reference

PivotTable Interface

PivotTable Members

Microsoft.Office.Interop.Excel Namespace