Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
3 years ago

Sound or Notification when Excel/Power Query refresh is complete

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?

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    I use a Macro for almost all my reports however the downside is for it to work you have to turn off the background refresh for all queries and turn on the fast load option (thinking about it now you can probably just set it for the loaded query but I've never tried that!).  If you dont it'll just ping the MsgBox straight away 😞

     

    Sub RefreshAll()
    '
    ' RefreshAll Macro
    ActiveWorkbook.RefreshAll

    MsgBox "Update Complete", vbInformation, "Update"

    End Sub

     

    If you find a better way I'd be interested as it is frustrating locking up excel whilst reports are updating!!

     

    Thanks,