PivotTable.RefreshDate (Excel)

Returns the date on which the PivotTable report was last refreshed.

For OLAP data sources, this property is updated after each query.

Dim dtRefreshDate As Date
dtRefreshDate = ActiveCell.PivotTable.RefreshDate