PivotTable.RefreshTable Method (Excel)
Refreshes the PivotTable report from the source data. Returns True if it’s successful.
Syntax
expression .RefreshTable
expression A variable that represents a PivotTable object.
Return Value
Boolean
Example
This example refreshes the PivotTable report.
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.RefreshTable