XlPivotTableSourceType Enumeration
Specifies the source of the report data.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlPivotTableSourceType
'Usage
Dim instance As XlPivotTableSourceType
public enum XlPivotTableSourceType
Members
Member name | Description | |
---|---|---|
xlScenario | Data is based on scenarios created using the Scenario Manager.. | |
xlConsolidation | Multiple consolidation ranges | |
xlDatabase | Microsoft Excel list or database | |
xlExternal | Data from another application | |
xlPivotTable | Same source as another PivotTable report |