Share via


PivotCache.RefreshDate Property

Excel Developer Reference

Returns the date on which the cache was last refreshed. Read-only Date.

Syntax

expression.RefreshDate

expression   A variable that represents a PivotCache object.

Remarks

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.

Example

This example displays the date on which the PivotTable report was last refreshed.

Visual Basic for Applications
  Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
dateString = Format(pvtTable.RefreshDate, "Long Date")
MsgBox "The data was last refreshed on " & dateString

See Also