Share via

XlPivotTableSourceType Enumeration

  • Article

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.