Power Query Problems

Fix Power Query Unable to Connect to Current Workbook Error

WPS Editor Sep 28, 2026 869 views

Question details

The user needs to resolve a connection error that prevents importing data into Power Query from the same workbook that is currently open.

Fix Power Query Unable to Connect to the Current Workbook

Product: Microsoft Excel
Device & OS: not provided
Scenario: Attempting to use Power Query to fetch data from the same workbook that is currently active.
Observed behavior: Power Query displays an unable to connect error when the user tries to use the external workbook connector to select the open file.

Before you start

Ensure your dataset is properly formatted with clear column headers, and save any recent changes in your workbook before launching the query editor.

Solution 1Recommended

Use the From Table/Range Feature

The most reliable way to query data from the currently active workbook is by converting it to an Excel Table and using the dedicated internal connector.

When you use the standard 'From File' connector, the system attempts to read the file from your hard drive as an external entity. Since the file is already open, it is locked, which triggers the unable-to-connect error. Using the internal 'From Table/Range' feature safely bypasses this lock.

Select your dataset

Click any cell inside the data range that you want to import into Power Query.

Convert data to a Table

Press the Ctrl + T keyboard shortcut. Confirm that the range is correct, check 'My table has headers', and then click OK.

Load into Power Query

Navigate to the Data tab on the ribbon and click on 'From Table/Range' in the Get & Transform Data group.

Apply queries

The Power Query Editor will open automatically with your data loaded via the Excel.CurrentWorkbook() function, allowing you to edit without connection errors.

Dynamic Updates: Using Tables ensures that any new rows or columns added later are automatically included in your query upon refreshing.

Solution 2

Create a Named Range for the Query Source

If you prefer not to use an Excel Table, you can define a Named Range to pull data into Power Query using a Blank Query.

Free Microsoft Office alternative

Try WPS Office for Seamless Data Management

While resolving advanced Power Query errors in Excel can be frustrating, WPS Office offers a lightweight, highly compatible alternative for everyday spreadsheet tasks, data analysis, and visualization. Enjoy a smooth experience without complex connection locks.

1. Download the software: Visit the official WPS Office website and download the free installation package.
2. Install WPS Office: Run the installer and follow the quick setup wizard to install the suite on your device.
3. Open your spreadsheets: Launch WPS Spreadsheet and easily open your existing Excel workbooks to start working immediately.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv).Free to use with a lightweight, fast-loading interface.Built-in tools for sorting, filtering, and pivot tables.Familiar tabbed workspace for a seamless migration.

microsoft office alternative - wps office

Frequently Asked Questions

Why do I get an 'unable to connect' error in Power Query?

This error typically occurs when you use the external 'From Workbook' connector to import data from the exact same file that is currently open. The system locks the open file, preventing the external connector from reading it.

Can I query data from multiple sheets in the current workbook?

Yes. You can create a Blank Query and type the formula = Excel.CurrentWorkbook() without specifying a particular name. This generates a list of all Tables and Named Ranges in the active workbook, which you can then filter, expand, and combine.

Do I have to format my data as a table to use Power Query?

While it is highly recommended because Excel Tables dynamically update when new data is added, you can also use Named Ranges as a source to import data into Power Query without converting it to a table format.

Excel & Data Problems