RefreshName Property

Applies To

PivotTable Object.

Description

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

See Also

RefreshDate Property, RefreshTable Method.

Example

This example displays the name of the person who last refreshed the PivotTable.

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