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