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, the PivotTable.RefreshByWho property returns the name of the user who last refreshed the report. The following example demonstrates this feature, and the sample file can be downloaded from the link below.

SourcePivotTable.xlsx

Sample Code