Expand Minimize

XlPivotTableSourceType Enumeration (Excel)

Specifies the source of the report data.

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.

Show:
© 2014 Microsoft