PivotTable.RefreshDate property (Excel)
Returns the date on which the PivotTable report was last refreshed. Read-only Date.
Syntax
expression.RefreshDate
expression A variable that represents a PivotTable object.
Remarks
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
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.
Commenti e suggerimenti
https://aka.ms/ContentUserFeedback.
Presto disponibile: Nel corso del 2024 verranno gradualmente disattivati i problemi di GitHub come meccanismo di feedback per il contenuto e ciò verrà sostituito con un nuovo sistema di feedback. Per altre informazioni, vedereInvia e visualizza il feedback per