Excel.PivotTable.RefreshName.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
PivotTable.RefreshName property (Excel)	vbaxl10.chm235091	vbaxl10.chm235091	Excel.PivotTable.RefreshName	488d5e0c-61f9-0c85-ac1b-16dc98360bb4	05/09/2019	medium

PivotTable.RefreshName property (Excel)

Returns the name of the person who last refreshed the PivotTable report data. Read-only String.

Syntax

expression.RefreshName

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 name of the person who last refreshed the PivotTable report.

Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable 
MsgBox "The data was last refreshed by " & pvtTable.RefreshName

[!includeSupport and feedback]