PivotTable.RefreshTable Method

Syntax

expression.RefreshTable

expression A variable that represents a PivotTable object.

Return Value
Boolean

Example

This example refreshes the PivotTable report.

Visual Basic for Applications
`Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable pvtTable.RefreshTable`

Recalculate pivottable from source data? refresh refresh table Refresh Table Method RefreshTable RefreshTable Method Replace old pivottable values with fresh ones? Update pivottable?

Refreshes the PivotTable report from the source data. Returns True if it's successful.

See also: