Help

[baby16]

Hi All



I have tried so many scenarios - I have a query in excel that I have set up to refresh automatically. However it will not update.



The file is in sharepoint, Then  I have tried a Script to refresh all and link it to a power automate.

That too is saying successful but not refreshing file.

My Ultimate goal is to refresh this automatically overnight without human intervention



Any ideas please?

 

[alansidman]

Why not refresh when opening the file?

 

[edwardjohn]

Hi baby16
Make sure the query is set to refresh automatically when the file opens or at specific intervals in the "Connection Properties." If Power Automate isn't working, consider using Windows Task Scheduler with a PowerShell script to open the file and refresh the query overnight.