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
expression.RefreshTable
expression Required. An expression that returns a PivotTable object.
This example refreshes the PivotTable report.
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
pvtTable.RefreshTable