XlPivotTableVersionList Enumeration
Specifies the version of a PivotTable or a PivotCache. Creating PivotTables with a specific version ensures that tables created in Microsoft Office Excel behave in the same manner as they did in the corresponding version of Excel.
Version Information
Version Added: Excel
| Name | Value | Description |
|---|---|---|
| xlPivotTableVersion2000 | 0 | Excel Version 2000 |
| xlPivotTableVersion10 | 1 | Excel Version 10 |
| xlPivotTableVersion11 | 2 | Excel Version 11 |
| xlPivotTableVersion12 | 3 | Excel Version 12 |
| 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. |