XlPivotTableSourceType Enumeration
Specifies the source of the report data.
Version Information
Version Added: Excel 2007
| Name | Value | Description |
|---|---|---|
| xlConsolidation | 3 | Multiple consolidation ranges. |
| xlDatabase | 1 | Microsoft Excel list or database. |
| xlExternal | 2 | Data from another application. |
| xlPivotTable | -4148 | Same source as another PivotTable report. |
| xlScenario | 4 | Data is based on scenarios created using the Scenario Manager. |