PivotCaches Method
Applies To
Workbook object.
Description
Returns a PivotCaches collection that represents all the PivotTable caches in the specified workbook. Read-only.
Syntax
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