Share via

PivotField.ShowAllItems Property

  • Article

True if all items in the PivotTable report are displayed, even if they don’t contain summary data. The default value is False. Read/write Boolean.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Property ShowAllItems As Boolean
    Get
    Set
'Usage
Dim instance As PivotField
Dim value As Boolean

value = instance.ShowAllItems

instance.ShowAllItems = value

bool ShowAllItems { get; set; }

Property Value

Type: System.Boolean

Remarks

For OLAP data sources, the value is always False.

See Also

Reference

PivotField Interface

PivotField Members

Microsoft.Office.Interop.Excel Namespace