The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

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.

Community Additions

© 2015 Microsoft