I have a bunch of pivot tables that are updated automatically from external SQL cubes at roughly 4 hour intervals. The user has access to the dates/times when cubes are refreshed, and I'm trying to include the date when the pivot data was last refreshed as well (many users work on these tables and don't want data refreshed, but want to know if there is a newer version available).

The only way I was able to do it is via pivottableupdate, but .RefreshDate shows me when the table was modified (so if I change a filter item it counts as updated). Same with just using a NOW function each time the sheet is refreshed. Is there any way to get the date and time of when pivot table data itself is refreshed, not counting various pivot table modificatons? Thanks in advance.