PivotTable.RefreshName Property (Excel)
TOC
Collapse the table of content
Expand the table of content
This documentation is archived and is not being maintained.

PivotTable.RefreshName Property (Excel)

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

expression .RefreshName

expression A variable that represents a PivotTable object.

For OLAP data sources, this property is updated after each query.

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
Show:
© 2016 Microsoft