XlPivotTableVersionList Enumeration

Excel Developer Reference

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

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


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.