Does Excel Power Query Refresh Automatically When Excel Is Closed?
Question details
The user needs to know whether Power Query can refresh data automatically after an Excel workbook is closed.
- Product
- Microsoft Excel Power Query
- Device & OS
- not provided
- Scenario
- The user wants scheduled or background data refreshes without keeping the Excel workbook open.
- Observed behavior
- Excel's built-in Power Query refresh process normally does not run after the workbook is closed.
Open the workbook and check the query's refresh settings under Data > Queries & Connections or Data > Refresh All. Confirm that the data source credentials and network connection work before choosing an automation method.
Keep the Excel workbook open for automatic Power Query refreshes
Use this approach when Excel's built-in background or scheduled refresh settings are sufficient and the computer can remain signed in with the workbook open.
Excel normally performs Power Query refreshes through the open workbook session. Closing the file ends the Excel process that runs the built-in refresh.
Refresh timing can still depend on the data source, credentials, permissions, and Excel version.
Launch Excel and open the workbook that contains the Power Query connections.
Select Data > Queries & Connections, right-click the relevant connection, and choose Properties.
On the Usage tab, enable Refresh data when opening the file and, where available, Refresh every, then enter the refresh interval.
Save the workbook, leave it open, and keep the computer connected to the required data source so Excel can perform the refresh.
Use scheduled automation for a closed workbook
Choose this option when data must refresh while the Excel file is closed or when a reliable unattended process is required.
Move Everyday Spreadsheet Work to WPS Office
WPS Office is a free, lightweight Microsoft Office alternative with a familiar interface and strong compatibility with Excel workbooks. It supports seamless migration for routine spreadsheet editing and review, although Microsoft Power Query-specific automation remains an Excel or Microsoft service feature.
- 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the application launcher.
- 2. Open the Excel workbook: Choose Open from the WPS Office home screen and select the existing .xlsx or .xls file.
- 3. Review and edit the data: Use the Spreadsheet tools to inspect, format, calculate, and save the workbook in a compatible Microsoft Excel format.
Frequently Asked Questions
Can Excel Power Query refresh a closed workbook by itself?
Usually no. Excel's built-in Power Query refresh runs through the open Excel session, so the workbook generally must remain open for background or interval-based refreshes.
How do I set Power Query to refresh while Excel is open?
Open the workbook, go to Data > Queries & Connections, right-click a connection, select Properties, and use the Usage tab to enable Refresh data when opening the file or Refresh every.
What can refresh an Excel Power Query workbook while it is closed?
Use a scheduled service or script such as Power Automate, Power BI, PowerShell, Office Scripts where supported, or another process that can authenticate to the workbook and data source.
Why might an automated refresh fail even when the workbook is accessible?
The automation may lack data-source credentials, file permissions, network access, gateway configuration, or support for the specific connector. Check the service's run history and authentication settings.
Does WPS Office run Microsoft Excel Power Query refreshes?
WPS Office can open and edit compatible Excel workbooks, but it does not replace Microsoft's Excel Power Query engine or guarantee Power Query refresh automation. Use Excel or a Microsoft-supported automation service for that feature.
