PivotCache.Version Property

Excel Developer Reference

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

Version Information
 Version Added:  Excel 2007

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.

See Also