PivotCache.RefreshDate property (Excel)
Returns the date on which the cache was last refreshed. Read-only Date.
expression A variable that represents a PivotCache object.
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.
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
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.