PivotTable.DisplayImmediateItems Property (Excel)
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.
This example determines how the PivotTable was created and notifies the user. It assumes a PivotTable exists on the active worksheet.
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