Get Pivot Table refresh date and refresh by who information

Contents
[ ]

PivotTable.RefreshDate returns the date on which the PivotTable report was last refreshed. Similarly PivotTable.RefreshByWho property returns the name of the user who refreshed the report last time. Following example demonstrates this feature and sample file can be downloaded from the following link.

SourcePivotTable.xlsx

Sample Code