Edit

Share via

XlPivotTableSourceType Enum

  • Reference

Definition

Namespace:
Microsoft.Office.Interop.Excel
Assembly:
Microsoft.Office.Interop.Excel.dll

Specifies the source of the report data.

public enum class XlPivotTableSourceType
public enum XlPivotTableSourceType
Public Enum XlPivotTableSourceType
Inheritance
Enum
XlPivotTableSourceType

Fields

Name Value Description
xlPivotTable -4148

Same source as another PivotTable report
xlDatabase 1

Microsoft Excel list or database
xlExternal 2

Data from another application
xlConsolidation 3

Multiple consolidation ranges
xlScenario 4

Data is based on scenarios created using the Scenario Manager..

Applies to