How to Open Queries and Connections in Excel

How-to basics · Updated November 21, 2026

To open the Queries & Connections pane in Excel for Microsoft 365 on Windows, select Data > Queries & Connections. The pane opens at the right of the workbook; select its Queries or Connections tab to view the items you need. You can use it to inspect, refresh, and manage Power Query queries and workbook data connections.

Before you begin, open the workbook that contains the query or connection. If you are trying to find an item in a particular file, opening a different workbook will show that other file’s items instead. The instructions below cover Excel for Microsoft 365 on Windows; Mac and web versions may not offer the same connection-management controls.

What You’ll Need

  • Excel for Microsoft 365 on Windows, or a desktop Excel version that includes the Queries & Connections pane.
  • The workbook that contains the queries or connections. Save a copy first if you plan to change or remove a connection.
  • Permission to access the workbook and, if you plan to refresh data, access to its source, such as a file, database, or online service.

Step-by-Step

  1. Open the correct workbook. Start Excel and open the file whose data setup you want to inspect. If the workbook is already open, check its name in the title bar so you do not examine a different file by mistake. Queries and connections are generally associated with the workbook in which they were created, not with Excel as a whole.
  2. Go to the Data tab. On the ribbon, select Data. Look for the Queries & Connections command, usually in the data-related section of the ribbon. If the ribbon is minimized, click a ribbon tab to reveal its commands. You can also expand the ribbon using the ribbon display options near the top-right of the Excel window.
  3. Open the pane. Select Queries & Connections. A pane should appear along the right side of the Excel window. This is a viewing and management area; it does not replace the worksheet or automatically load a query’s data into a new sheet. If you do not see the command immediately, widen the Excel window or inspect the Data tab’s grouped commands for a collapsed or overflow option.
  4. Choose the Queries tab to see queries. In the pane, select Queries. Queries created with Power Query are listed here, often with information such as their load status or the number of rows. Select a query to make it active in the pane. Depending on the workbook and Excel build, you may be able to right-click a query for actions such as editing, refreshing, loading, or deleting it.
  5. Choose the Connections tab to see connections. Select Connections at the top of the pane. This view lists the workbook’s data connections that Excel recognizes. A connection is the link or set of settings used to reach a data source; it is not necessarily the data itself. Some queries use connections, so the lists can be related without being identical. If one tab is empty, check the other before concluding the workbook has no data setup.
  6. Inspect an item before changing it. Select or right-click a listed query or connection and look for the available commands. A query’s Edit command opens the Power Query Editor, where you can examine its steps and source. A connection’s properties, when available, show information such as how it is used or when it refreshes. Read the options carefully: editing a query can change the results loaded to a worksheet or the data model.
  7. Refresh only when you mean to update the data. If the goal is to see current source data, use the relevant refresh command from the pane or the Data tab. A refresh can contact a database, website, shared file, or other source and may take time. It can also require credentials or network access. Opening the pane alone does not refresh the workbook, so do not treat a displayed result as newly updated unless you have refreshed it or know when it was last refreshed.
  8. Close or reopen the pane as needed. To close it, select the pane’s close button. To open it again, return to Data > Queries & Connections. Closing the pane does not delete queries or break their connections; it only hides the on-screen panel. If you are managing a large workbook, keep the pane open while reviewing items and close it when you need more worksheet space.

In some desktop builds, you may also see a separate Connections command on the Data tab. It can open the older Workbook Connections dialog, which is useful for inspecting or managing certain connection types. Use the Queries & Connections pane first for the usual Power Query workflow. If a particular connection-management option is missing from the pane, check the Data tab for the separate command or right-click the relevant item. The exact ribbon arrangement can differ between Excel releases and window sizes.

Common Mistakes

  • Looking in the wrong workbook. The pane shows the queries and connections for the active workbook. If you have several files open, switch to the intended one before opening the pane.
  • Confusing queries with connections. A query describes steps for getting and transforming data; a connection describes how Excel reaches or uses a source. One may exist without an obvious matching item in the other list, and the two tabs are not interchangeable.
  • Assuming an empty tab means nothing exists. Check both tabs. A workbook may contain a query but no separately visible connection in the place you expected, or it may use a connection that is not represented as a Power Query item.
  • Expecting the pane to show worksheet data. The pane lists and manages query or connection objects. To see loaded results, look at the worksheet table or data model destination associated with the query.
  • Deleting an item just to hide it. Delete can remove a query or connection from the workbook and may affect reports, tables, or refreshes that depend on it. Close the pane if you only want to clear the screen.
  • Refreshing before checking access. Refresh may fail if you are offline, signed out, or no longer permitted to access the source. Confirm the source is available before repeatedly refreshing.

Tips

  • Use the pane to find query actions. Right-clicking an item often exposes context-sensitive commands. The menu differs according to the item type and workbook, so inspect it before choosing an action.
  • Use Power Query Editor for transformation steps. If you need to understand how a query changes its source data, open it for editing and review the Applied Steps list. Avoid changing steps unless you understand how the change may affect downstream reports.
  • Check where results are loaded. A query can be loaded to a worksheet table, loaded to the data model, or set up as a connection without a visible worksheet table. Look at the query’s load options if you cannot find its output on a sheet.
  • Distinguish pane refresh from editing. Refresh attempts to retrieve updated data; Edit opens the query definition. Choose based on whether you want new source results or want to inspect the transformation.
  • Keep the workbook saved before structural changes. Saving a copy gives you a way back if a change to a query or connection affects a report. This is especially useful in shared workbooks or files with many dependent queries.
  • Allow for version differences. Excel for Mac may have Power Query features, but the ribbon layout and connection-management options can differ. Excel for the web has a more limited set of desktop data tools. If you cannot find a control or need to manage a legacy connection, use Excel desktop on Windows where possible.

Troubleshooting

The Queries & Connections button is missing. First make sure you are on the Data tab and that the ribbon is expanded. Maximize the Excel window; narrow windows can collapse commands into smaller groups or overflow menus. If the command still is not available, check your Excel version and whether you are using the desktop app rather than Excel for the web. Some older builds arrange data commands differently.

The pane does not appear after clicking the command. Look along the right edge of the Excel window; it may have opened behind another pane or at a very narrow width. Close unrelated side panes and try the command again. If the workbook window is unusually small, maximize it. You can also close and reopen the workbook if the interface appears stuck, after saving any changes.

The pane appears, but a query or connection is missing. Confirm that the correct workbook is active, then check both the Queries and Connections tabs. Some data may be present as a worksheet table without a query, or the source may have been imported by a method that does not appear in the list you are viewing. Check the Data tab’s separate Connections command if your version provides it. If the workbook was created in another Excel version, opening it in a supported desktop version may expose additional controls.

Refresh fails or asks for credentials. Check your internet or network connection and confirm that the source file, database, or service is available. If prompted, sign in using the account authorized for that source. A changed file path, expired password, missing driver, or organization policy can also block refresh. If you do not own the source or credentials, ask the workbook owner or IT administrator before changing connection settings.

Excel for Mac or the web does not show the same options. The pane and available commands vary by platform and release. On Mac, check the Data tab for query-related controls, but do not assume Windows ribbon paths or legacy connection dialogs are present. Excel for the web may let you view or refresh some data, but it does not provide every desktop editing and connection-management feature. For full management, open the workbook in Excel for Microsoft 365 on Windows.

Frequently Asked Questions

How do I open Queries & Connections in Excel?
Select Data > Queries & Connections in Excel for Microsoft 365 on Windows. The pane opens at the right of the workbook.

How do I see only the connections?
Open the pane and select its Connections tab. If you need the older Workbook Connections dialog, look for a separate Connections command on the Data tab; availability and placement can vary by version.

Why is the Queries tab empty?
The active workbook may not contain Power Query queries, or you may have the wrong workbook open. Check the Connections tab too, and remember that a worksheet table does not always mean a query is present.

Does opening the pane refresh my data?
No. Opening the pane only displays query and connection information. Use a refresh command when you want Excel to request updated data from the source.

Can I open Queries & Connections in Excel for the web?
Some web versions provide data-query features, but the available controls do not match Excel desktop in every case. For editing queries or managing less common connections, use the desktop app.

Will closing the pane remove my queries?
No. Closing the pane only hides it. Your queries and connections remain in the workbook unless you choose a command that removes or changes them.

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.