PivotTable.DisplayImmediateItems Property

Syntax

expression.DisplayImmediateItems

expression A variable that represents a PivotTable object.

Example

This example determines how the PivotTable was created and notifies the user. It assumes a PivotTable exists on the active worksheet.

Visual Basic for Applications

Visual Basic for Applications
`Sub CheckItemsDisplayed() Dim pvtTable As PivotTable Set pvtTable = ActiveSheet.PivotTables(1) ' Determine how the PivotTable was created. If pvtTable.DisplayImmediateItems = True Then MsgBox "Fields have been added to the row or column areas for the PivotTable report." Else MsgBox "The PivotTable was created by using object-model calls." End If End Sub`

Sub CheckItemsDisplayed() Dim pvtTable As PivotTable Set pvtTable = ActiveSheet.PivotTables(1) ' Determine how the PivotTable was created. If pvtTable.DisplayImmediateItems = True Then MsgBox "Fields have been added to the row or column areas for the PivotTable report." Else MsgBox "The PivotTable was created by using object-model calls." End If End Sub

display immediate items displayimmediate displayimmediateitems displayimmediateitems property

PivotTable.DisplayImmediateItems Property

Returns or sets a Boolean that indicates whether items in the row and column areas are visible when the data area of the PivotTable is empty. Set this property to False to hide the items in the row and column areas when the data area of the PivotTable is empty. The default value is True.

See also: