Excel.PivotTable.RefreshDate.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.RefreshDate property (Excel)	vbaxl10.chm235090	vbaxl10.chm235090	Excel.PivotTable.RefreshDate	7c1a29c2-749e-98f8-ae14-eb2fa3ab2bb1	05/09/2019	medium

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

[!includeSupport and feedback]