RefreshName Property

Applies To

PivotCache object, PivotTable object.

Description

Returns the name of the person who last refreshed the PivotTable data or pivot cache. Read-only String.

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