Export (0) Print
Expand All

Workbook.PivotCaches Method

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

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



Community Additions

ADD
Show:
© 2014 Microsoft