PivotTableSourceType enumeration

PivotTableSourceType enumeration

Represents data source type of the pivot table.

The PivotTableSourceType type exposes the following members:

Fields

FieldDescription
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.

See Also