Muokkaa

Jaa

PivotTable.RefreshName property (Excel)

  • Artikkeli

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

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

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.