RefreshTable Method

Applies To

PivotTable object.

Description

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

Syntax

expression.RefreshTable

expression Required. An expression that returns a PivotTable object.

See Also

RefreshDate property, RefreshName property.

Example

This example refreshes the PivotTable.

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