Fix Excel Power Query Stuck Connecting to a Local Workbook
Question details
The user needs Excel Power Query to connect to another workbook stored on a local drive.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- Connecting to a local Excel workbook through Power Query after installing Office 365.
- Observed behavior
- The connection remains on the Connecting screen for every workbook tested. The issue began with the Office 365 installation.
Confirm that the source workbook is on an accessible local drive and can be opened directly in Excel. In Excel, check that the Data tab includes Get Data or Get & Transform Data.
Use the built-in Get & Transform connector
Use Excel's included Power Query tools rather than installing the older standalone add-in.
Microsoft 365 includes Power Query as Get & Transform. The older add-in may not be installed, so check before trying to remove it.
In Excel on Windows, open File > Options > Add-ins. Check the installed add-ins list for a separate Power Query add-in; if it is absent, continue to the next step.
If the older Power Query add-in appears, select the appropriate add-in type in the Manage box, click Go, and clear its checkbox. Do not disable unrelated add-ins.
On the Data tab, select Get Data > From File > From Workbook, choose the local source workbook, and click Import.
In the Navigator window, select a sheet or table and click Load or Transform Data. If Excel remains on Connecting, continue with the checks below.

Check local workbook access
Test whether Excel can open the source file independently of Power Query.
Update or repair the Office installation
Try these installation checks when connections hang for multiple accessible workbooks.
Work with local Excel files in WPS Spreadsheet
WPS Office is a free, lightweight alternative with a familiar interface for opening and editing local spreadsheets. Its Excel format compatibility makes it easier to move existing files, though it does not repair Microsoft Excel Power Query connections or guarantee equivalent query support.

Frequently Asked Questions
Do I need to install the Power Query add-in for Microsoft 365?
No. Excel for Microsoft 365 includes Power Query under Data > Get Data or Get & Transform Data. The older standalone add-in is not needed.
How do I connect Power Query to another local workbook?
Select Data > Get Data > From File > From Workbook, choose the file, and select the sheet or table in Navigator. Then click Load or Transform Data.
What if Excel can open the workbook but Power Query still hangs?
Test a newly created local workbook using Data > Get Data > From File > From Workbook. If that also hangs, check for Office updates and, on Windows, try repairing the installation.
Will removing the old add-in definitely fix the connection?
Not necessarily. The add-in may not be installed, and connections can still hang for other reasons. Check local file access and update or repair Office if the problem affects every workbook.




