PivotTableSourceType

PivotTableSourceType enumeration

Utility class containing constants. Represents the pivot table data source type.

Values

NameDescription
SHEETSpecifies that the source data is a range.
EXTERNALSpecifies that external source data is used.
CONSOLIDATIONSpecifies that multiple consolidation ranges are used as the source data.
SCENARIOThe source data is populated from a temporary internal structure.
UNKNOWNUnknown data source.
PivotTableSelectionType Enum PivotTableStyleType Enum