PivotAreaType

PivotAreaType enumeration

Indicates the type of rule being used to describe an area or aspect of the PivotTable.

Values

NameValueDescription
None0No Pivot area.
Normal1Represents a header or item.
Data2Represents something in the data area.
All3Represents the whole PivotTable.
Origin4Represents the blank cells at the top-left of the PivotTable (top-right for RTL sheets).
Button5Represents a field button.
TopRight6Represents the blank cells at the top-right of the PivotTable (top-left for RTL sheets).