Sound or Notification when Excel/Power Query refresh is complete

(0) Share

Report

Posted on by dbliss

In Excel I have multiple pivot tables tied to about 40 Power Queries which takes about 10-15 minutes to refresh on a fast desktop PC (AMD Ryzen 7 2700X 8 core at 3.7GHz w 32 GB RAM, DDR4 on Win11-64 Pro.). I'd like to get a notification (ring/text/email) when the refresh is complete. Perhaps there's a Power Query function out there that can pass data to a VBA object when the refresh process is complete, but I haven't found it. Can anyone help?