Power Query Problems

Check Whether an Excel Workbook Uses Power Query

Steven ParkerSteven Parker Nov 12, 2026 868 views

Question details

The user needs to determine whether an Excel workbook contains Power Query queries or connections to external data sources.

Product
Microsoft Excel
Device & OS
not provided
Scenario
A workbook owner wants to inspect the workbook's queries and data connections before analyzing or editing its external data.
Observed behavior
The workbook's Power Query queries and other data connections are listed in the Queries & Connections pane.
Before you start

Open the workbook in the desktop version of Excel and confirm that the Data tab is available. If Excel displays an external-content prompt, review it before inspecting the workbook's connections.

Solution 1Recommended

Use Excel's Queries & Connections pane

Use this method when you need to see whether the current workbook contains Power Query queries or other external data connections.

1
Open the Data tab

Open the workbook in Excel, then select the Data tab on the ribbon.

2
Open Queries & Connections

Select Queries & Connections in the Data ribbon to open the workbook's connection pane.

3
Review the listed items

Check the Queries and Connections sections in the pane. Listed queries indicate Power Query content, while other entries identify workbook data connections.

What the pane confirms: If the pane contains queries or connections, the workbook uses Power Query or another external-data connection. An empty pane indicates that Excel does not currently show any such items in the workbook.
Free Microsoft Office alternative

Use WPS Office for Compatible Excel Workbook Editing

WPS Office is a free, lightweight alternative for opening, reviewing, and editing Excel workbooks when you do not need to manage Microsoft Power Query connections. Its familiar interface and strong Excel format compatibility make migration straightforward.

  1. 1. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the Start menu or applications list.
  2. 2. Open the Excel workbook: Select Menu > Open, choose the .xlsx or .xls workbook, and review its sheets and visible data.
  3. 3. Edit or save the workbook: Make any required changes, then choose Menu > Save As and retain the Excel .xlsx format when sharing the file with Microsoft Office users.
Open and edit Microsoft Excel .xlsx and .xls files with familiar spreadsheet tools.Use a lightweight, free office suite for everyday workbook review and editing.Work with common spreadsheet formulas, tables, charts, and formatting.Review workbook content smoothly when Power Query management is not required.
microsoft office alternative - wps office

Frequently Asked Questions

Where can I find Power Query queries in Excel?

Open the workbook, select Data on the ribbon, and choose Queries & Connections. Any Power Query queries appear in the Queries section of the pane.

Does an empty Queries & Connections pane mean the workbook has no Power Query?

Usually, yes. If no queries or connections appear, Excel does not currently detect any listed Power Query items or external data connections in that workbook. Check that you opened the correct file and are using a desktop Excel version that supports the feature.

How can I see where an Excel Power Query gets its data?

Open Data > Queries & Connections, select the query, and choose Edit. Power Query Editor shows the source step and the transformations applied to the imported data.

Can WPS Office inspect or edit Power Query connections?

WPS Office can open and edit compatible Excel workbooks, but it does not replace Excel's Power Query management tools. Use Microsoft Excel to view, edit, refresh, or remove Power Query connections.