RefreshPeriod Property Example

This example sets the refresh period for the PivotTable cache (PivotTable3) to 15 minutes.

Set objPC = Worksheets("Sheet1").PivotTables("PivotTable3").PivotCache
objPC.RefreshPeriod = 15