XlPivotTableSourceType enumeration (Excel)
Specifies the source of the report data.
| 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. |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.