Timestamp for last refresh in pivot table

jayjay123

New Member
Joined
Jun 3, 2021
Messages
44
Office Version
  1. 365
Platform
  1. Windows
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!
 

Excel Facts

How to total the visible cells?
From the first blank cell below a filtered data set, press Alt+=. Instead of SUM, you will get SUBTOTAL(9,)
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.
 
Upvote 0
Add this function to your workbook:

VBA Code:
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:

Excel Formula:
=LastRefreshInfo(A3)
 
Upvote 0

Forum statistics

Threads
1,212,928
Messages
6,110,734
Members
448,294
Latest member
jmjmjmjmjmjm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top