PivotTable.RefreshName Property

Syntax

expression.RefreshName

expression A variable that represents a PivotTable object.

Remarks

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

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

See also:

• PivotTable Object
• PivotTable Object Members