Refresh Query automatically Excel PowerQuery

[o0omax]

Hello,

I have a Query combining multiple Excel file which lie on a network drive of our company. I saw the possibility of refreshing the Query periodically (see picture). WIll this query refresh e.g. every 60 min, even if Excel is not opened or my laptop is off?

[Anonymous · Accepted solution]

Hi @o0omax ,

Refresh every x minutes – This option controls how often a query is refreshed. This only operates if the workbook is open. It is useful when the source data is regularly changing. It is probably a good idea only to use this option with the background refresh enabled, or it could become very annoying for users to wait for Excel to update on a regular basis.

If you want to learn more about it, please refer to

Refresh Power Query in Excel: 4 ways + advanced options - Excel Off The Grid

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.