This documentation is archived and is not being maintained.

XlPivotTableSourceType Enumeration 

Specifies the source of the report data.

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

Dim xlPivotTableSourceType1 As XlPivotTableSourceType = XlPivotTableSourceType.xlConsolidation

public enum XlPivotTableSourceType
public enum XlPivotTableSourceType
public enum XlPivotTableSourceType

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

Development Platforms

Windows XP Home Edition, Windows XP Professional, Windows Server 2003, and Windows 2000

Target Platforms