Excel.PivotCache.RefreshDate.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotCache.RefreshDate property (Excel)	vbaxl10.chm227081	vbaxl10.chm227081	Excel.PivotCache.RefreshDate	0bbb3e62-584b-7daf-2ad0-643a6e886187	05/03/2019	medium

PivotCache.RefreshDate property (Excel)

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.

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

[!includeSupport and feedback]