Hello All,
Looking for help in creating a title for a pivot table which would include the most recent date the pivot table was refreshed. Below I have the formula for the original title where the date was entered based on whatever 'today' is. But I'd like to replace that logic with the pivot's most recent refresh date. Meaning, if the last refresh date is today (April 13th, 2022), and I open the file again on Friday, April 15th - I want the title to still say 4-13-22. However if I fresh the pivot table, the date should immediately update.
=CONCATENATE("Report Dated ",TEXT(TODAY(),"m-dd-yy"))
Also, I saw a thread that shows VBA code I could enter into the Worksheet->PivotTableUpdate screen. I've put the below code in and am waiting for tomorrow to see if the date remains as 4-13, then updates is I update the Pivot.
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Range("A2").Value = Date
End Sub
Any help would be most appreciated.
Thanks!
Looking for help in creating a title for a pivot table which would include the most recent date the pivot table was refreshed. Below I have the formula for the original title where the date was entered based on whatever 'today' is. But I'd like to replace that logic with the pivot's most recent refresh date. Meaning, if the last refresh date is today (April 13th, 2022), and I open the file again on Friday, April 15th - I want the title to still say 4-13-22. However if I fresh the pivot table, the date should immediately update.
=CONCATENATE("Report Dated ",TEXT(TODAY(),"m-dd-yy"))
Also, I saw a thread that shows VBA code I could enter into the Worksheet->PivotTableUpdate screen. I've put the below code in and am waiting for tomorrow to see if the date remains as 4-13, then updates is I update the Pivot.
Private Sub Worksheet_PivotTableUpdate(ByVal Target As PivotTable)
Range("A2").Value = Date
End Sub
Any help would be most appreciated.
Thanks!
