Forum Discussion

Botty1963

Copper Contributor

Dec 19, 2023

Power query auto refresh

I set up my file to auto-refresh, and I followed the instructions I found on the web. However, it does not refresh in the background, and I have now read another post that says the file must be open ...

excel

SergeiBaklan

Diamond Contributor

Dec 19, 2023

Botty1963

File is to be opened. Workarounds are with using of PowerShell, Power BI services, etc

How to auto-refresh Power Query query, without opening the Excel file, when said file is on sharepoint/Teams? : r/excel (reddit.com)

vba - Is it possible to schedule the data refresh of a power query in excel to refresh data at 2 specific times every day? - Stack Overflow

etc

Botty1963

Copper Contributor

Dec 22, 2023

Many thanks Sergei.