This documentation is archived and is not being maintained.

XlPivotTableSourceType Enumeration

Office 2007
Specifies the source of the report data.

Version Information
 Version Added:  Excel 2007

NameValueDescription
xlConsolidation3Multiple consolidation ranges.
xlDatabase1Microsoft Excel list or database.
xlExternal2Data from another application.
xlPivotTable-4148Same source as another PivotTable report.
xlScenario4Data is based on scenarios created using the Scenario Manager.


Show: