Refresh Method Example

This example refreshes the PivotTable cache for the first PivotTable report on worksheet one.

Worksheets(1).PivotTables(1).PivotCache.Refresh