RefreshDate Property

Applies To

PivotTable Object.

Description

Returns the date when the PivotTable was last refreshed. Read-only.

See Also

RefreshName Property, RefreshTable Method.

Example

This example displays the date on which the PivotTable was last refreshed.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
dateString = Format(pvtTable.RefreshDate, "Long Date")
MsgBox "The data was last refreshed on " & dateString