This documentation is archived and is not being maintained.

XlPivotTableVersionList Enumeration

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

Version Information
 Version Added:  Excel 2007

xlPivotTableVersion20000Excel Version 2000
xlPivotTableVersion101Excel Version 10
xlPivotTableVersion112Excel Version 11
xlPivotTableVersion123Excel Version 12
xlPivotTableVersionCurrent-1Provided only for backward compatibility


Bb241438.vs_note(en-us,office.12).gif  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.