Skip to main content

Workbook.PivotCaches method

Table of contents
  1. Syntax
  2. Return value
  3. Example

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



expression A variable that represents a Workbook object.

Return value



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

ActiveWorkbook.PivotCaches(1).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>