PivotCache.Refresh Method

Excel Developer Reference

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.

Visual Basic for Applications
  Worksheets(1).PivotTables(1).PivotCache.Refresh

See Also