This topic has not yet been rated - Rate this topic

PivotCaches Collection Object [Excel 2003 VBA Language Reference]

Office 2003

Represents the collection of memory caches from the PivotTable reports in a workbook. Each memory cache is represented by a PivotCache object.

Using the PivotCaches Collection

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

For Each pc In ActiveWorkbook.PivotCaches
    pc.RefreshOnFileOpen = True
Next

Properties | Application Property | Count Property | Creator Property | Parent Property

Methods | Add Method | Item Method

Parent Objects

Child Objects

Did you find this helpful? Yes No

Not accurate

Not enough depth

Need more code examples

(1500 characters remaining)