Office Apps Crashing

Fix Excel Crashes When Saving XLSB Files After Power Query Update

Camila MilosovichCamila Milosovich Oct 29, 2026 871 views

Question details

The user experiences consistent application crashes when attempting to save an Excel Binary Workbook (.xlsb) immediately following a Power Query update.

How to Fix Excel Crashing When Saving an XLSB File After a Power Query Update
Product
Microsoft Excel 2016
Device & OS
not provided
Scenario
Saving an XLSB file that contains multiple queries or complex data connections after a recent Power Query update.
Observed behavior
Excel crashes completely without successfully saving the binary workbook.
Before you start

Ensure you save a copy of your original data source files in a standard format (like XLSX or CSV) to prevent data loss while troubleshooting the crash.

Solution 1Recommended

Test with a New Workbook and Report the Bug

Determine if the issue is file-specific or a systemic bug, and report the crash directly to Microsoft for a patch.

Since this crash often stems from a specific Power Query update interacting poorly with the XLSB format, verifying the bug in a fresh file is the best first step. Reporting it helps expedite an official hotfix.

1
Create a new workbook

Open Excel and select 'Blank workbook' to start a fresh file.

2
Transfer sample data

Copy a small portion of your data and paste it into the new workbook.

3
Attempt to save as XLSB

Navigate to 'File' > 'Save As', select 'Excel Binary Workbook (*.xlsb)' from the format dropdown, and click 'Save'.

4
Report the issue

If Excel crashes during the test save, open Excel again, go to 'File' > 'Feedback', and click 'Send a Frown'. Include details about the Power Query update and your Office build number.

Test with a New Workbook and Report the Bug
Free Microsoft Office alternative

Try WPS Office for Stable Spreadsheet Management

If Microsoft Excel continues to crash due to unresolved Power Query bugs, consider switching to WPS Office. It provides a highly stable environment for handling complex spreadsheets and large datasets without the frequent crashing issues.

  1. 1. Download WPS Office: Visit the official WPS website to download and install the free software.
  2. 2. Open your spreadsheet: Launch WPS Spreadsheets and open your XLSB or XLSX file directly.
  3. 3. Edit and save safely: Continue your work and save your data without worrying about application crashes.
Excellent compatibility with all major Microsoft Excel formats, including XLSB, XLSM, and XLSX.Lightweight architecture ensures smooth performance even with large data sets.Free to use with a familiar user interface, requiring zero learning curve.Reliable file saving mechanisms that prevent unexpected application crashes.
microsoft office alternative - wps office

Frequently Asked Questions

What is an XLSB file?

An XLSB file is an Excel Binary Workbook. Unlike standard XLSX files which are XML-based, XLSB files store data in binary format. This allows them to read and write data much faster, making them ideal for exceptionally large or complex spreadsheets.

Why does Power Query cause Excel to crash when saving?

Crashes typically occur due to memory management bugs or conflicts introduced in recent Office updates. When Power Query pulls complex data, saving it immediately into the compressed binary (XLSB) format can sometimes overload the application's memory processing, leading to a crash.

Can I roll back my Excel to a previous version before the update?

Yes. If the crash severely impacts your workflow, you can use the Microsoft Office Deployment Tool or specific command-prompt instructions to revert your Office installation to an earlier, more stable build version.