RefreshTable Method

Microsoft Excel Visual Basic

RefreshTable Method

       

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

expression.RefreshTable

expression   Required. An expression that returns a PivotTable object.

Example

This example refreshes the PivotTable report.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.RefreshTable