RefreshOnFileOpen Property Example

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

ActiveWorkbook.PivotCaches(1).RefreshOnFileOpen = True