PivotTableSourceType
PivotTableSourceType enumeration
Represents data source type of the pivot table.
Values
| Name | Value | Description |
|---|---|---|
| Sheet | 1 | Specifies that the source data is a range. |
| External | 2 | Specifies that external source data is used. |
| Consolidation | 4 | Specifies that multiple consolidation ranges are used as the source data. |
| Scenario | 8 | The source data is populated from a temporary internal structure. |
| Unknown | 9 | Unknown data source. |