Timestamp for last refresh in pivot table

[jayjay123]

Hi Excel Gurus,

I have a spreadsheet, two (tabs) are data input manually.
I used a power query to format the data.
Then I used a pivot table.
To refresh the table, I must select "Data > Refresh All"

Is there a way to display the last refresh date and/or refreshed by who? for when my pivot table

Thank you!

 

[awoohaw]

Im not entirely sure if this works. But F9 recalculates workbooks.
if your file is not huge, you can put a =Today() function in a cell somewhere and when ever the workbook recalculates either by entering a formula in a cell, or recalculating it will recalculate. Youl could also check to see if the formula recalcualtes when you refresh the pivot data.

 

[RoryA]

Add this function to your workbook:

Function LastRefreshInfo(Cell As Range)
   With Cell.PivotTable
      LastRefreshInfo = "Refreshed on " & Format$(.RefreshDate, "dd/mm/yyyy hh:mm:ss") & " by " & .RefreshName
   End With
End Function

Then enter the function in a cell, passing a cell in the pivot table as the argument - for example:

=LastRefreshInfo(A3)