The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotCache.Version Property

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

Version Information
 Version Added:  Excel 2007



expression   A variable that represents a PivotCache object.


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.

Community Additions

© 2015 Microsoft