Share via

PivotCaches Method

  • Article

Returns a PivotCaches collection that represents all the PivotTable caches in the specified workbook. Read-only.

expression**.PivotCaches**

expression   Required. An expression that returns a Workbook object.

Example

This example causes the PivotTable cache to update automatically each time the workbook is opened.

  ActiveWorkbook.PivotCaches(1).RefreshOnFileOpen = True