Expand Minimize

Workbook.PivotCaches Method (Excel)

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

expression .PivotCaches

expression A variable that represents a Workbook object.

Return Value


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

ActiveWorkbook.PivotCaches(1).RefreshOnFileOpen = True
© 2014 Microsoft