Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

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