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.