| title | api_name | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|
XlPivotTableSourceType enumeration (Excel) |
|
96385c0c-3f03-7b57-fb71-af533270a26c |
06/08/2017 |
medium |
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. |
[!includeSupport and feedback]