Export (0) Print
Expand All
Expand Minimize

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.


Community Additions

ADD
Show:
© 2015 Microsoft