Get Pivot Table Refresh Date and Refresh‑by‑Who Information

How to Get Pivot Table Refresh Date and Refresh‑by‑Who Information

PivotTable.getRefreshDate() returns the date on which the PivotTable report was last refreshed. Similarly, the PivotTable.getRefreshedByWho() property returns the name of the user who refreshed the report most recently. The following example demonstrates this feature, and the sample file can be downloaded from the link below.

SourcePivotTable.xlsx

Sample Code