Excel Power Query Not Responding? Fixes That Work

How-to basics · Updated November 21, 2026

If Excel Power Query is not responding, wait briefly to see whether a large refresh is still running, then cancel it if Excel offers that option. Save a copy of the workbook before trying fixes; next, check the data source, refresh settings, and query steps to find what is actually stalled.

First, determine what has stopped responding

“Power Query is not responding” can describe several different situations. Excel might be busy refreshing data, the Power Query Editor might be frozen while evaluating a step, or Excel itself might have stopped responding. The distinction matters: a slow source can make a healthy query look stuck, while an Excel crash may require a different response.

Look for clues before closing the program:

  • Excel shows a refresh or progress message: A source may be returning a large amount of data, or Excel may be processing transformations. Check whether the progress indicator changes and whether the source is still accessible.
  • The Power Query Editor opens, but a preview takes a long time: A particular step may be expensive, or the editor may be waiting for a file, database, or network location.
  • The whole Excel window is unresponsive: Give it a reasonable interval, especially if the workbook is large. If there is no progress and the operating system reports that Excel is not responding, the application may need to be closed.
  • Only one query fails: Focus on that query’s source, credentials, and applied steps rather than assuming the entire workbook is damaged.

Some refreshes legitimately take minutes, particularly when they retrieve many rows or depend on a slow network service. Repeatedly clicking Refresh All can start additional work or make it harder to tell which operation is active. Avoid clicking around in a window that is clearly busy.

Protect the workbook before troubleshooting

If Excel still responds, save the workbook before making changes. For important work, use File > Save As to create a separate troubleshooting copy. This preserves the original query definitions and gives you a way back if a change produces a different result.

If the application is completely frozen, avoid immediately ending the task if the workbook contains unsaved edits. Wait and see whether Excel recovers. If it does not, close it through the operating system only as a last resort, then reopen Excel and check Document Recovery for an unsaved version. Recovery is not guaranteed, so a previously saved copy is safer than relying on it.

Do not delete query steps or clear credentials at random. A query can contain transformations, privacy choices, and connection details that are not obvious from the worksheet. Record the error message and the query name first. If you have to test a risky change, do it in the duplicate workbook.

Cancel a refresh and isolate the affected query

When a refresh is active, look for a cancel control in Excel’s refresh or status indicator. In the Queries & Connections pane, a query that is actively refreshing may also offer a cancellation command when you right-click it. The available command depends on what Excel is doing; if no cancellation option appears, do not assume that pressing keys will safely stop the operation.

After Excel becomes responsive, open Data > Queries & Connections. This pane helps distinguish a query that is still refreshing from one that has already returned an error. Right-click a query and choose Edit to inspect it in Power Query Editor. If just one query is problematic, refresh that query rather than the whole workbook. This narrows the investigation and avoids needlessly reloading unrelated data.

For a query with many applied steps, select steps one at a time in the Query Settings pane. If the preview becomes slow immediately after a particular transformation, that step is a useful lead. For example, merging a large table with another table before filtering either one can require substantial processing. A source that takes a long time to respond, however, can cause a delay before the first transformation is reached.

Check the data source, network, and permissions

Power Query retrieves data from a source, so a refresh can stall even when the workbook is fine. Confirm that the source is available outside Excel: open the file, visit the service, or check that the database or network location is reachable. A file moved to a different folder, a disconnected VPN, a changed server address, or an expired sign-in can prevent a query from completing.

For a local or shared file, check that its path has not changed and that you have permission to read it. For a database or online service, confirm that you can sign in and that your account still has access. If a credential needs refreshing, go to Data > Get Data > Data Source Settings, select the relevant source, and use the available permission or sign-in options. Clearing permissions can require you to authenticate again, so do it only when you know which source you are changing.

Power Query also applies privacy levels to sources to help control how data from different locations is combined. A privacy prompt or Formula.Firewall error is not the same as a frozen application. Review the source privacy settings under Data > Get Data > Query Options and choose a level appropriate to the data and your organization’s rules. Do not disable privacy checks simply to make a query run; doing so can weaken protections when queries combine information from different sources.

Review refresh settings and query design

A query can refresh in the background, which allows some Excel work to continue while data loads. To inspect this behavior, open Data > Queries & Connections, right-click the relevant query, choose Properties, and review the Usage tab. If the option is available, temporarily turning off Enable background refresh can make the refresh behavior easier to observe. It does not make a slow source faster, and Excel may remain occupied until the operation finishes.

Also check whether the workbook is refreshing queries automatically when it opens or at a scheduled interval. An automatic refresh can create the impression that Excel is frozen as soon as the file opens. Query properties vary by connection type, so not every setting appears for every query.

In the editor, look for transformations that increase the amount of work:

  • Filter rows early when the source and query support it. Some sources can process filters before sending data to Excel, a technique known as query folding; not every source or transformation supports it.
  • Avoid loading intermediate queries to a worksheet if they are only needed as inputs to other queries. Use the query’s load options deliberately rather than producing unnecessary copies of data.
  • Check merges and appends for unexpectedly large tables, duplicate keys, or mismatched column types. A merge can produce far more rows than expected when the matching column is not unique.
  • Remove columns that are not needed, especially before later operations that sort, group, or join large datasets.

These are design improvements, not emergency buttons. Make one change at a time and compare the result with the original output. A faster refresh is not useful if a filter or merge changes which records the workbook includes.

Check Excel, add-ins, and available resources

Large workbooks and data sets can put pressure on memory and processing capacity. Close other demanding applications, ensure the computer has free disk space, and allow Excel time to finish before starting another refresh. If the workbook repeatedly hangs with several unrelated queries, test whether the issue occurs in a copy of the file and in a different workbook. That helps separate a query-specific problem from an Excel or computer problem.

Install available Microsoft 365 updates through File > Account > Update Options > Update Now, if that option is present. The exact update controls can depend on how Microsoft 365 is managed by an organization. If the problem began after installing an Excel add-in, try starting Excel in Safe Mode: close Excel, then hold Ctrl while opening it and confirm the Safe Mode prompt. If Power Query behaves differently there, an add-in may be involved. Safe Mode is a diagnostic step, not a repair for a broken source or query.

On Windows, if Excel will not start or continues to fail across workbooks, use Windows’ installed-app repair options for Microsoft 365. Repair choices and labels vary by Windows release and installation type. Consider an online repair only after saving work and checking with your organization’s IT team if the device is managed.

Windows, Mac, and Excel for the web differences

The steps above describe Excel for Microsoft 365 on Windows. Power Query features and source support are not identical across platforms. Excel for Mac has Power Query capabilities, but available connectors and authoring features can differ from Windows, and some instructions or dialog names may not match exactly. If a query was created on Windows and has an unsupported feature on Mac, editing or refreshing it there may not be equivalent.

Excel for the web also does not provide the same full query-authoring experience as desktop Excel. Refresh support depends on the query, data source, account, and current service capabilities. If the web version cannot edit or refresh a particular query, open the workbook in a supported desktop version rather than assuming the query is corrupt. For a work or school workbook, an administrator may also control connections and authentication.

When to force close, recover, or ask for help

Force-closing Excel is reasonable only when it has stopped responding for an extended period, there is no visible progress, and waiting has not restored control. On Windows, Task Manager can end an unresponsive Excel process; this can discard unsaved changes and should be a last resort. On Mac, use Force Quit only after the same considerations. Reopen the workbook, inspect recovery options, and avoid immediately repeating Refresh All.

If the issue returns, keep a short record of the query name, source type, last successful refresh, error text, and whether the problem affects other workbooks. For an organization-managed database or cloud source, give that information to the data or IT team. For a workbook-specific issue, share a sanitized copy when permitted; workbooks can contain sensitive data, credentials, or private connection details, so do not send the original indiscriminately.

Frequently Asked Questions

Why is Power Query stuck on Evaluating?
“Evaluating” means Excel is processing a query step or waiting on a source; it does not by itself identify the cause. Check whether the source is reachable, then test the query’s steps in order to see where the delay begins. Large merges, network delays, and unavailable credentials are common possibilities.

Can I close Excel if Power Query is not responding?
Wait first, because a large refresh may still complete. If Excel remains unresponsive with no progress, you may need to force it closed, but unsaved changes can be lost. Reopen the workbook and check Document Recovery rather than assuming every change was saved.

How do I stop Power Query from refreshing automatically?
Open Data > Queries & Connections, right-click the query, choose Properties, and review the refresh options on the Usage tab. Settings vary by connection type. Disabling a refresh-on-open or background option changes when a query runs; it does not repair its source.

Will disabling background refresh fix a frozen query?
Not necessarily. It can make refresh behavior easier to monitor, but the query still has to retrieve and process its data. If the source is offline, credentials are invalid, or a transformation is unusually expensive, address that underlying cause.

Why does Power Query work on one computer but not another?
The computers may have different Excel versions, connector support, permissions, credentials, network access, or privacy settings. Check those differences before rebuilding the query, and verify that both devices can reach the same source.

Does a frozen Power Query mean my data is lost?
No. A stalled refresh does not automatically mean the source data or query has been erased. However, unsaved workbook edits may be lost if Excel must be force-closed. Keep a saved copy and verify the workbook’s last refresh and loaded results after recovery.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.