PivotTable.RefreshDate Property

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

See also:

• PivotTable Object
• PivotTable Object Members