Share via


XlPivotTableVersionList Enumeration

Specifies the version of a PivotTable or a PivotCache. Creating PivotTables with a specific version ensures that tables created in Microsoft Excel 2010 behave in the same manner as they did in the corresponding version of Excel.

Version Information

Version Added: Excel 2007

Name

Value

Description

xlPivotTableVersion2000

0

Excel 2000

xlPivotTableVersion10

1

Excel 2002

xlPivotTableVersion11

2

Excel 2003

xlPivotTableVersion12

3

Excel 2007

xlPivotTableVersion14

4

Excel 2010

xlPivotTableVersionCurrent

-1

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.