Refresh Method Example
This example refreshes the PivotTable cache for the first PivotTable report on worksheet one.
Worksheets(1).PivotTables(1).PivotCache.Refresh