PivotTable.RefreshName (Excel)

Returns the name of the person who last refreshed the PivotTable report data.

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

Dim strRefreshName As String
strRefreshName = ActiveCell.PivotTable.RefreshName