Before exiting file prompt a note with a reminer

[wherdzik]

I have a file that I have created with a number of pivot tables. The users always forget to refresh some of the pivot tables before sending back to me. Which makes me do double the work.
Is there a vba code that I can slice in that when the user exists the file a prompt comes up with a final reminder. I would add a custom note in there.

Thank you kindly.

-newbie

[MrShorty]

That sounds like you want a beforeclose event procedure:
https://www.dummies.com/software/mic...vent-examples/
https://access-excel.tips/excel-work...reclose-event/

Using those examples, it should be straightforward to create beforeclose procedure that asks if the pivot tables are refreshed and block if the user indicates they are not.

Alternatively, you could use the refreshall method to force all pivot tables to update as part of the beforeclose event procedure and not worry about reminding/asking the user. This example shows the refreshall method in a change event, but it should be easy enough to adapt it to a beforeclose event: https://www.excelcampus.com/vba/refr...automatically/

[LJMetzger]

There is also a 'Pivot Table' option you can set that automatically refreshes the Pivot Table when the file opens. For details see: https://support.office.com/en-us/art...Newer_versions

Lewis