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 |