Edit

Share via

PivotCache.Version property (Excel)

  • Article

Returns the version of Microsoft Excel in which the PivotCache was created. Read-only XlPivotTableVersionList.

Syntax

expression.Version

expression A variable that represents a PivotCache object.

Remarks

This property returns the version of the PivotTable. Default settings and behaviors depend on the version to allow for old PivotTable object model code to run in Microsoft Office Excel 2007 with the same behaviors when the version of the PivotTable corresponds to the version of Excel for which the code was written.

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.