May 12 2022 09:05 PM
I created a video that demos how to use Power Automate Cloud and Desktop to trigger a VBA macro on a schedule in unattended mode on an Excel file resident on SharePoint Online (SPO).
You can use VBA to refresh an external data query. So, this means you can refresh an external data query for an Excel file resident on SPO.
Update : Microsoft has recently announced the part-enablement of Query Refreshing for Excel Online.
See the 1 minute intro video here: https://www.youtube.com/watch?v=u6ppPk3r0T0
See the full demo here: https://www.youtube.com/watch?v=owI4LyQb2xE
You comments are welcome.