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.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property DisplayImmediateItems As Boolean
Get
Set
'Usage
Dim instance As PivotTable
Dim value As Boolean
value = instance.DisplayImmediateItems
instance.DisplayImmediateItems = value
bool DisplayImmediateItems { get; set; }
Property Value
Type: System.Boolean