PivotCache.Refresh Method (Excel)
Causes the specified chart to be redrawn immediately.
Syntax
expression .Refresh
expression A variable that represents a PivotCache object.
Example
This example refreshes the PivotTable cache for the first PivotTable report on the first worksheet in a workbook.
Worksheets(1).PivotTables(1).PivotCache.Refresh