Check Whether an Excel Workbook Uses Power Query
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.
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.
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.
Open the workbook in Excel, then select the Data tab on the ribbon.
Select Queries & Connections in the Data ribbon to open the workbook's connection pane.
Check the Queries and Connections sections in the pane. Listed queries indicate Power Query content, while other entries identify workbook data connections.
Inspect individual query details in Excel
Use this option when you need to identify the source, transformations, or destination of a listed Power Query.
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. Install WPS Office: Download and install WPS Office, then open WPS Spreadsheets from the Start menu or applications list.
- 2. Open the Excel workbook: Select Menu > Open, choose the .xlsx or .xls workbook, and review its sheets and visible data.
- 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.

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.




