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

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

Remarks

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

ADD
Show:
© 2014 Microsoft