Power Query Problems

Fix Power Query or Microsoft Query Not Working After Saving in Excel

John Wilson Oct 23, 2026 868 views

Question details

Users experience an issue where Power Query or Microsoft Query works correctly at first, but becomes completely unresponsive or unavailable after the Excel file is saved and reopened.

How to Fix Power Query or Microsoft Query Stopping After Saving in Excel

Product: Microsoft Excel
Device & OS: not provided
Scenario: Importing and transforming external data using Power Query or Microsoft Query within an Excel workbook.
Observed behavior: The queries function initially but stop working, disappear, or fail to refresh once the workbook is saved, closed, and reopened.

Before you start

Ensure your Excel application is fully updated to the latest version, and verify that your network connection is stable if you are linking to cloud data sources.

Solution 1Recommended

Isolate the Issue Using a New Workbook and Local Data

Create a test workbook with a simple local data source to determine if the problem is specific to your original workbook or the original data connection.

By testing a completely new file and a local data source, you can determine if the original workbook has become corrupted or if the issue stems from a network-based source like SharePoint Online.

Create a New Workbook

Open Excel, click on the File tab, and select 'Blank workbook' to start a fresh environment.

Connect to Local Data

Go to the Data tab, click 'Get Data' (or 'New Query'), and select a simple local Excel file or CSV from your computer as the test data source.

Save and Reopen

Save the new workbook to your local drive. Close Excel entirely, then reopen the file to check if the Power Query connection remains active.

Test Original Sources

If the local file works flawlessly, try connecting this new workbook to your original source (such as SharePoint Online). Take note of any changes or errors that occur to pinpoint network or permission issues.

Isolate the Issue Using a New Workbook and Local Data

Document Your Steps: Record exactly what actions you take immediately before the issue begins, as this can help identify conflicting add-ins or specific transformation steps causing the failure.

Solution 2

Verify Excel Version and Account Settings

Check your Office account details to ensure your license is active and your version supports advanced Power Query features.

Free Microsoft Office alternative

Try WPS Office for Stable Data Management

If Microsoft Excel continues to experience crashing or broken queries after saving files, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling spreadsheets, analyzing data, and viewing complex workbooks without the heavy resource drain.

1. Download WPS Office: Visit the official WPS website to download the free installation package for your operating system.
2. Install and Launch: Run the installer, open WPS Spreadsheet, and explore the intuitive workspace.
3. Open Your Workbooks: Click 'Open' and select your existing .xlsx files to continue your data management tasks seamlessly.

Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) formats.Lightweight software that opens complex datasets quickly without freezing.Familiar user interface requiring zero learning curve.Seamless and stable file saving without losing basic data connection integrity.

microsoft office alternative - wps office

Frequently Asked Questions

Why does Power Query disappear after saving my Excel file?

This usually happens due to a corrupted workbook cache, incompatible COM add-ins, or network connection drops when linking to cloud sources like SharePoint. Isolating the issue in a fresh workbook helps identify the exact cause.

Can I recover my Power Query connections if they stop working?

Sometimes you can restore functionality. Navigate to the Data tab, click 'Queries & Connections', and attempt to refresh the source. If the pane is entirely blank or grayed out, the data model within that specific file may be corrupted.

Does clearing the Power Query cache help with saving issues?

Yes. Go to Data > Get Data > Query Options > Data Load, and select 'Clear Cache'. This forces Excel to rebuild the data connection from scratch upon reopening, which can resolve saving-related freezes.

Is there a limit to how much data Power Query can save without failing?

While Excel worksheets are limited to 1,048,576 rows, Power Query can load millions of rows directly into the Data Model. However, exceeding your system's available RAM or running 32-bit Office can cause the application to fail when attempting to save the data model.

Excel & Data Problems