Skip to main content

PivotCaches object

Table of contents
  1. Remarks
  2. Example

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


Each memory cache is represented by a PivotCache object.


Use the PivotCaches method of the Workbook object 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

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>