Muokkaa

Jaa

PivotTable.RefreshDate property (Excel)

  • Artikkeli

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.