Excel.PivotTable.ShowPageMultipleItemLabel.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.ShowPageMultipleItemLabel property (Excel)	vbaxl10.chm235150	vbaxl10.chm235150	Excel.PivotTable.ShowPageMultipleItemLabel	2f816331-4017-a208-d1b2-fea219d2ca71	05/09/2019	medium

PivotTable.ShowPageMultipleItemLabel property (Excel)

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.

Syntax

expression.ShowPageMultipleItemLabel

expression A variable that represents a PivotTable object.

Example

This example determines if "(Multiple Items)" will be displayed in the PivotTable cell and notifies the user. The example assumes that a PivotTable exists on the active worksheet.

Sub UseShowPageMultipleItemLabel() 
 
 Dim pvtTable As PivotTable 
 
 Set pvtTable = ActiveSheet.PivotTables(1) 
 
 ' Determine if multiple items are allowed. 
 If pvtTable.ShowPageMultipleItemLabel = True Then 
 MsgBox "The words 'Multiple Items' can be displayed." 
 Else 
 MsgBox "The words 'Multiple Items' cannot be displayed." 
 End If 
 
End Sub

[!includeSupport and feedback]