XlPivotTableVersionList Enumeration
Specifies the version of a PivotTable or a PivotCache. Creating PivotTables with a specific version ensures that tables created in behave in the same manner as they did in the corresponding version of Excel.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Public Enumeration XlPivotTableVersionList
'Usage
Dim instance As XlPivotTableVersionList
public enum XlPivotTableVersionList
Members
| Member name | Description | |
|---|---|---|
| xlPivotTableVersion2000 | Excel 2000 | |
| xlPivotTableVersion10 | Excel 2002 | |
| xlPivotTableVersion11 | Excel 2003 | |
| xlPivotTableVersion12 | Excel 2007 | |
| xlPivotTableVersion14 | Excel 2010 | |
| xlPivotTableVersionCurrent | Provided only for backward compatibility |
Remarks
Note
xlPivotTableVersionCurrent is included only for backward compatibility reasons. It cannot be used with new PivotCache and PivotTable objects. There are no differences in behavior between xlPivotTableVersion11 and xlPivotTableVersion10.