PivotAreaType enumeration

PivotAreaType enumeration

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

The PivotAreaType type exposes the following members:

Fields

FieldDescription
NONENo Pivot area.
NORMALRepresents a header or item.
DATARepresents something in the data area.
ALLRepresents the whole PivotTable.
ORIGINRepresents the blank cells at the top-left of the PivotTable (top-right for RTL sheets).
BUTTONRepresents a field button.
TOP_RIGHTRepresents the blank cells at the top-right of the PivotTable (top-left for RTL sheets).

See Also