Skip to main content

PivotCache.RefreshOnFileOpen property

Table of contents
  1. Syntax
  2. Remarks
  3. Example

True if the PivotTable cache is automatically updated each time the workbook is opened. The default value is False. Read/write Boolean.



expression A variable that represents a PivotCache object.


Query tables and PivotTable reports are not automatically refreshed when you open the workbook by using the Open method of the Workbooks object in Visual Basic. Use the Refresh method to refresh the data after the workbook is open.


This example causes the PivotTable cache to automatically update 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>