Power Query Problems

Fix Excel Power Query Stuck Connecting to a Local Workbook

Camila MilosovichCamila Milosovich Nov 14, 2026 868 views

Question details

The user needs Excel Power Query to connect to another workbook stored on a local drive.

Fix Excel Power Query Stuck Connecting to a Local Workbook
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.
Before you start

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.

Solution 1Recommended

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.

1
Check for the older add-in

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.

2
Disable the older add-in if present

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.

3
Connect through Get Data

On the Data tab, select Get Data > From File > From Workbook, choose the local source workbook, and click Import.

4
Choose the source data

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.

Use the built-in Get & Transform connector
Free Microsoft Office alternative

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.

Open and edit local spreadsheet workbooksCompatible with Microsoft Excel formats such as XLSX and XLSFamiliar spreadsheet interface for an easier transitionFree and lightweight office suite
microsoft office alternative - wps office

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.