If Power Query’s Close & Load appears to do nothing, first check whether the query is set to create a connection only or load to the Data Model instead of a worksheet. In Excel for Microsoft 365 on Windows, open Data > Queries & Connections, right-click the query, choose Load To, and select Table plus a worksheet location; if that option is unavailable or loading produces an error, the steps below help isolate why.
What Close & Load is supposed to do
Power Query separates preparing data from deciding where to put the result. In the Power Query Editor, Home > Close & Load closes the editor and applies the query’s current load settings. It does not always mean “put a visible table on a new worksheet.” A query can be configured as a connection, sent to the Data Model, or loaded to an existing destination.
To choose the destination explicitly, use the arrow beside Close & Load in the editor and select Close & Load To. In the dialog, choose Table and either a new worksheet or an existing worksheet location. The available choices can depend on the query and workbook. You can also open Excel’s Queries & Connections pane, right-click the query, and select Load To.
Closing the editor is not necessarily the same as refreshing data later. If a query has already been loaded, changing its steps generally changes the query definition; use Data > Refresh All or right-click the query and choose Refresh to update the loaded result. A preview in the editor is a preview of the query output, not proof that the output has been placed on a worksheet.
Check the query’s load settings first
The most common explanation is a load destination that is different from the one you expected. In Excel, select Data > Queries & Connections to open the pane. A query listed there may be working even when you cannot see a table: it may be connection-only, used by another query, or loaded to the Data Model for PivotTables or other analysis.
Right-click the query and choose Load To. To create a visible result, select Table, then choose New worksheet or specify an empty cell on an existing sheet. If you select Only Create Connection, Excel keeps the query available to the workbook without placing its rows in a worksheet table. That can be intentional for a staging query that feeds another query.
A query added to the Data Model may be useful for a PivotTable but will not appear as an ordinary table of rows on a worksheet. If you need to inspect or edit its load choice, use the query’s Load To settings. Before changing a destination, consider whether other queries or reports depend on the existing connection or model entry.
Work through a reliable troubleshooting sequence
Try these checks in order, changing one thing at a time. This helps distinguish a destination problem from a source, refresh, or workbook problem.
- Wait for the editor to finish. If the preview is still evaluating, allow it to complete. For a large file or a slow network source, loading can take longer than closing the editor itself.
- Confirm the query name and output. In the editor, check the final step in the Applied Steps list and make sure the preview shows the rows and columns you expect. A filter, removed-rows step, or error-handling step may have reduced the output to no rows.
- Set a visible destination. In Excel’s Queries & Connections pane, right-click the query, select Load To, and choose Table and a new worksheet. This is a useful diagnostic because it avoids conflicts with an existing output area.
- Check for a refresh or source error. If Excel displays an error, read its details before changing credentials, permissions, or query steps. A query can have a valid preview from cached data but fail when it tries to access the source again.
- Refresh after loading. If the table exists but does not reflect your recent edits, use Data > Refresh All. Check that the query is not merely showing a previously loaded result.
- Save, close, and reopen a copy. If the commands remain unresponsive, save the workbook, close Excel, reopen it, and try again. Keep an untouched copy before making larger changes to query destinations or workbook structure.
When the table is missing, blank, or in the wrong place
First look for a new worksheet tab; Excel may have created one away from the sheet you are viewing. Then check the Queries & Connections pane to see whether the query is listed and inspect its load settings. If a table is present but has no data rows, the query may genuinely return zero rows. The column headings can still appear, so an empty table does not by itself prove that loading failed.
For an existing-worksheet destination, verify the selected cell and look for content or other tables in the intended output area. Loading into a new worksheet is a simple way to avoid an unsuitable destination while diagnosing the problem. Also check whether a worksheet filter is hiding rows, or whether the query itself filters them out. Clear a worksheet filter only if you want to see all rows already loaded; edit the query if its filter is part of the transformation.
If the query is connection-only, it may still be used as an input to another query. Loading every intermediate query to a sheet can create unnecessary copies of data and make a workbook harder to manage. Choose a worksheet table when people need to inspect the rows directly; keep a connection-only setting when the query is only a reusable preparation step.
Separate load failures from refresh and source errors
Close & Load can trigger work that depends on the source, so an apparent loading problem may actually be a refresh problem. Common causes include a disconnected network drive, an unavailable website or database, changed sign-in details, a moved or renamed source file, and insufficient permission to read the source. The error message and the source named in the query are more useful clues than repeatedly clicking the load command.
Open the query in the editor and select Home > Refresh Preview if you need to see whether it can retrieve current source data. If prompted, use the appropriate credentials for that source. For queries that combine sources, Power Query’s privacy settings can also affect how data is combined; do not lower privacy protections simply to dismiss an error unless you understand the implications and your organization permits it.
Some connections can refresh in the background. If the query appears to keep running or the workbook seems busy, right-click it in Data > Queries & Connections and inspect Properties, if available. For a connection that offers a background-refresh setting, turning it off can make the workbook wait for completion and help with diagnosis. The setting’s availability depends on the connection type, and it will not fix a broken source or invalid credentials.
Check workbook and Excel conditions
Excel may not be able to write a result where you expect if the destination sheet or workbook structure is restricted. If the worksheet is protected, try an authorized unprotected sheet or ask the workbook owner to permit the intended change. If the workbook is shared, read-only, or being edited in a location with limited permissions, save an editable copy and test there. Do not remove protection from a workbook unless you have permission.
A large query can also take time or consume substantial memory, especially when it returns many rows, combines multiple sources, or performs expensive transformations. Close other demanding workbooks and try loading a smaller filtered result to determine whether scale is a factor. A smaller test is for diagnosis; it does not establish that the full query is correct. If a reduced version loads, review the source size and transformations before attempting the full result again.
Finally, make sure you are using the desktop Excel app rather than expecting the Power Query Editor’s desktop controls in Excel for the web. Power Query support in the web app and the available editing or refresh capabilities can differ by source and Microsoft 365 environment. On Mac, Power Query availability and supported connectors or features can also differ from Excel for Windows, and ribbon locations may not match exactly. If a Windows instruction is missing on your platform, check the current Excel version and its Power Query support rather than assuming the workbook is damaged.
Choose the right fix for the symptom
Use the symptom to avoid making unnecessary changes to a working query:
- Nothing appears on a sheet, but the query is listed: check whether it is connection-only or loaded to the Data Model, then choose Load To > Table if a worksheet result is required.
- The table appears but shows old values: refresh the query and investigate source access or credentials if refresh fails.
- The preview is correct but loading fails: test a new worksheet destination and read any error details. This points toward a destination or workbook issue rather than a transformation-preview issue.
- The query finishes but returns no rows: inspect filters and the final applied steps, then compare the source data with the conditions in the query.
- Only one source or workbook fails: investigate that source’s path, permissions, credentials, and availability before rebuilding the query.
Rebuilding a query should be a last resort, not the first fix. A query can include carefully configured steps, data types, parameters, and dependencies that are easy to lose. If you must make a copy for testing, preserve the original and verify that dependent queries and reports still use the intended version.
Frequently Asked Questions
Why does Power Query say Close & Load but create no worksheet?
The query may be set to create a connection only or to load to the Data Model. In Excel, open Data > Queries & Connections, right-click the query, choose Load To, and select Table with a worksheet destination if you need visible rows.
How do I make Power Query load to an existing sheet?
Choose Close & Load To in the Power Query Editor, or use Load To from the query’s context menu in the Queries & Connections pane. Select Table and Existing worksheet, then specify the destination cell. Choose a suitable empty location to avoid conflicts with existing content.
Why does Close & Load not update my existing table?
The editor may have closed without a refresh of the data, or the source may not have refreshed successfully. In Excel, use Data > Refresh All and check for a source or credential error. Also confirm that you edited the query that feeds the table you are inspecting.
Is connection-only the same as a failed load?
No. Connection-only is a valid load choice: it stores the query connection without placing its output in a worksheet table. It is often used for intermediate queries that another query uses. Change it to a table only if you need to view the result directly on a sheet.
Can I use Power Query Close & Load in Excel for the web or Mac?
Power Query features, connectors, and controls vary across Excel for the web, Mac, and Windows. The instructions here are for Microsoft 365 on Windows. If a command or connector is unavailable on another platform, check that platform’s current Excel support and, where appropriate, open the workbook in desktop Excel for Windows.
Related
- Excel Number Format for Indian Rupees: ₹ and Lakhs
- Excel Number Format Color Codes and Custom Formats
- Excel Number Format Brackets for Negative Numbers Explained
Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.
More in Errors & fixes
- Outlook Email Not Working Today? Check These FixesIf Outlook email is not working today, check Microsoft’s service-health page first, then test the same account in…
- Excel Freeze Panes Not Working? Fix Common Excel IssuesIf Excel won’t freeze panes, first switch to View > Normal, click the cell just below and to…
- COUNTA Excel Not Working? Find the CauseIf COUNTA seems wrong, first check what is actually in the cells: the function counts any nonempty cell,…
- Excel #REF! Error: How to Fix Broken Cell ReferencesTo fix an Excel #REF! error, edit the formula that displays it and replace the invalid reference with…
- Excel Not Working on Mac? Fixes for Common ProblemsIf Excel is not working on your Mac, first check whether the problem affects the app, one workbook,…
- Excel File Not Opening? Fix the Blank Screen in ExcelIf Excel opens to a blank screen, first check whether the workbook window is hidden, then start Excel…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.