Share via


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.