PivotTable.RefreshTable Method (Excel)

  • Article

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

See Also

Concepts

PivotTable Object

PivotTable Object Members