Data Tab "Refresh/All" Button Triggering Macro

[AlexaS]

I have what I would think would be a very easy question, but nothing I've found has answered it for me. I apologize if this has been answered (please respond with the link to the answer if it has) but I can't find anything.

What I need to do is this: when an end user clicks the "Refresh" or "Refresh All" button under the Data tab and/or under the Pivot Table Tool options tab (for the entire workbook), a macro needs to run that plops a date/time stamp into a predefined cell in the workbook. I can get the date/time stamp, no problem. I can't get it to run by pressing the button on the tab.

Additional points:
- I've tried doing the macro recorder and when I step through what was recorded (ActiveWorkbook.RefreshAll), the macro works just fine.
- The requirement is to be able to push the "Refresh" or "Refresh All" button and not a separate macro button, because we can't trust the NUMEROUS people who utilize all of the files that my boss wants to add this to, to use the macro button instead of what they are used to

Any help would be appreciated. If I could implement something next week, my boss will probably be over the moon

Thanks!

 

[Andrew Poulsom]

From a quick test you can use the Workbook_SheetPivotTableUpdate event procedure.

 

[AlexaS]

Thank you that seems to be exactly what I needed!