Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotCaches Object

Office 2007
Represents the collection of memory caches from the PivotTable reports in a workbook.

Remarks

Each memory cache is represented by a PivotCache object.

Example

Use the PivotCaches method to return the PivotCaches collection. The following example sets the RefreshOnFileOpen property for all memory caches in the active workbook.

Visual Basic for Applications
For Each pc In ActiveWorkbook.PivotCaches
    pc.RefreshOnFileOpen = True
Next



Community Additions

Show:
© 2014 Microsoft