PivotTable.DisplayImmediateItems (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.


ActiveCell.PivotTable.DisplayImmediateItems = True