RefreshDate Property [Excel 2003 VBA Language Reference]
Returns the date on which the PivotTable report or cache was last refreshed. Read-only Date.
Remarks
For PivotCache objects, the cache must have at least one PivotTable report associated with it.
For OLAP data sources, this property is updated after each query.
Example
This example displays the date on which the PivotTable report was last refreshed.
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
dateString = Format(pvtTable.RefreshDate, "Long Date")
MsgBox "The data was last refreshed on " & dateString
Applies to | PivotCache Object | PivotTable Object
See Also | RefreshName Property | RefreshTable Method