XlPivotTableSourceType enumeration

Office 2013 and later

Specifies the source of the report data.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

Member nameDescription
xlScenarioData is based on scenarios created using the Scenario Manager..
xlConsolidationMultiple consolidation ranges
xlDatabaseMicrosoft Excel list or database
xlExternalData from another application
xlPivotTableSame source as another PivotTable report
Show: