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: