Syntax

expression.PivotCaches

expression A variable that represents a Workbook object.

Return Value
PivotCaches

Example

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

Visual Basic for Applications 
ActiveWorkbook.PivotCaches(1).RefreshOnFileOpen = True
access PivotCache pivot caches Pivot Caches Method PivotCaches pivotcaches method reference all caches workbook return all pivot table caches in a workbook

See also: