Date in cell to update upon Pivot Table refresh

  • Thread starter Thread starter chris46521
  • Start date Start date
C

chris46521

I would like to have a cell in my sheet update to the current date each
time data is refreshed in a pivot table. It would also be wonderful if
the same thing could be done for a chart as part of the title. Are any
of these possible with code? Thanks!
 
you could use the "Workbook_SheetPivotTableUpdate" or th
"Worksheet_PivotTableUpdate" event to place the current date in
particular cell each time the pivot table updates
 
Thanks for your response! Do you know what code I might use to make that
work? I am not that familiar with VBA. Thanks again.
 
You could use something like this if you want the current date time i
cell A1 when the pivot table updates. Remember to format cell A1 wit
the date time format you want.


Code
 
Thank you!
You could use something like this if you want the current date time in
cell A1 when the pivot table updates. Remember to format cell A1 with
the date time format you want.
Code:
Click to expand...
 
Back
Top