RefreshName Property 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