'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Fix Excel Power Query Queries Not Refreshing in a Report
Question details
The user is experiencing an issue where supplementary Power Query queries linked to a main report fail to refresh automatically when triggered.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Refreshing data in an Excel workbook containing multiple Power Query connections used by a main report.
- Observed behavior
- The queries do not update when a refresh is executed, but no error messages or warnings are displayed.
Ensure that your data sources are accessible and that you have saved your workbook before troubleshooting your Power Query connection settings.
Enable Refresh All for Query Connections
Ensure that each query is properly configured in its properties to update whenever the global Refresh All command is executed in the workbook.
Navigate to the Data tab on the Excel ribbon and click on 'Queries & Connections' to open the side pane.
Right-click the specific query that is failing to refresh in the side pane, then select 'Properties' from the context menu.
In the Query Properties dialog box, go to the Usage tab. Check the box labeled 'Refresh this connection on Refresh All'.
Click 'OK' to save your changes. Finally, go back to the Data tab and click 'Refresh All' to confirm the query now updates successfully.
Identify and Resolve Hidden Query Errors
Queries with internal errors may silently fail to refresh without triggering a prominent popup warning.
Restart Excel and Test on a Duplicate Workbook
If your settings are correct and no errors exist, a simple restart or testing on a clean copy can resolve temporary background glitches.
Try WPS Office for Seamless Spreadsheet Data Management
Experiencing complex Power Query or background refresh errors in Microsoft Excel? WPS Office provides a lightweight, highly compatible alternative for everyday spreadsheet tasks, data analysis, and reporting without the heavy system overhead.
Frequently Asked Questions
Why is the 'Refresh All' button greyed out in Excel?
The 'Refresh All' button may be disabled if the workbook structure is protected, if you are currently editing a cell, or if multiple sheets are grouped together. Ensure you exit cell editing mode by pressing Enter or Esc, and unprotect the worksheet under the Review tab.
Can background refresh settings prevent my queries from updating correctly?
Yes. If 'Enable background refresh' is checked, Excel might try to update queries simultaneously, which can cause conflicts in complex reports with dependent queries. You can disable this by going to Query Properties > Usage tab and unchecking 'Enable background refresh'.
How do I refresh a single Power Query instead of all connections?
To refresh a specific query, open the Queries & Connections pane from the Data tab, right-click the desired query, and select 'Refresh'. This bypasses the global Refresh All command and forces only that specific connection to update.
Does changing the source file location break the Power Query refresh?
Yes. If the original data source (like a CSV or another Excel file) is moved, renamed, or deleted, Power Query will fail to refresh because it cannot find the file. You must update the source path via Data > Get Data > Data Source Settings.
