RefreshDate Property

Applies To

PivotCache object, PivotTable object.

Description

Returns the date on which the PivotTable or pivot cache was last refreshed. Read-only Date.

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