Fix Excel Crashes When Saving XLSB Files After Power Query Update
Question details
The user experiences consistent application crashes when attempting to save an Excel Binary Workbook (.xlsb) immediately following 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.
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.
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.
Open Excel and select 'Blank workbook' to start a fresh file.
Copy a small portion of your data and paste it into the new workbook.
Navigate to 'File' > 'Save As', select 'Excel Binary Workbook (*.xlsb)' from the format dropdown, and click 'Save'.
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.

Update Office and Power Query
Installing the latest Microsoft Office patches may resolve known bugs related to Power Query and binary workbook saves.
Save as XLSM as a Temporary Workaround
Bypass the XLSB saving bug entirely by using the standard macro-enabled format until an official fix is released.
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. Download WPS Office: Visit the official WPS website to download and install the free software.
- 2. Open your spreadsheet: Launch WPS Spreadsheets and open your XLSB or XLSX file directly.
- 3. Edit and save safely: Continue your work and save your data without worrying about application crashes.

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.




