Causes the specified PivotCache 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