XlPivotTableVersionList enumeration

Office 2013 and later

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

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

Member nameDescription
xlPivotTableVersion2000Excel 2000
xlPivotTableVersion10Excel 2002
xlPivotTableVersion11Excel 2003
xlPivotTableVersion12Excel 2007
xlPivotTableVersion14Excel 2010
xlPivotTableVersion15Excel 2013
xlPivotTableVersionCurrentProvided only for backward compatibility

NoteNote

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.

Show: