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

See also

PivotTable Object