How to Fix Excel Cannot Save XLSB Workbooks with Macros
Question details
The user is unable to save large Excel Binary Workbooks (XLSB) that contain macros and external data connections.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to save modifications to a large XLSB file that utilizes macros and data connections.
- Observed behavior
- Excel fails to save the workbook, and the saving issue persists even after attempting standard troubleshooting steps like running an Office repair.
Before proceeding with repairs or add-in checks, attempt to 'Save As' your workbook in a different format (such as .xlsm) or save a copy to your local desktop to ensure you do not lose your recent changes.
Disable Excel Add-ins to Identify Conflicts
Third-party add-ins can sometimes conflict with Excel's saving processes, especially in large binary workbooks. Disabling them helps identify the culprit.
COM add-ins or custom Excel add-ins may interfere with how Excel writes binary data to your storage drive. Isolating the add-ins is the most effective first step in troubleshooting save failures.
Open Microsoft Excel, click on the 'File' tab in the top-left corner, and select 'Options' at the bottom of the menu. In the Excel Options window, click on 'Add-ins' on the left sidebar.
At the bottom of the window next to 'Manage', select 'COM Add-ins' from the dropdown and click 'Go...'. Uncheck all the add-ins in the list and click 'OK'.
Return to the 'Manage' dropdown, select 'Excel Add-ins', and click 'Go...'. Uncheck all items here as well, then click 'OK'.
Try saving your XLSB workbook again. If the save is successful, re-enable your add-ins one by one, saving after each, to pinpoint exactly which add-in is causing the error.

Repair the Microsoft 365 Installation
If core application files are corrupted, repairing your Microsoft 365 or Office installation can restore normal functionality for saving complex workbooks.
Contact Microsoft Support for Persistent Issues
If standard repairs fail, the issue might be related to your specific Microsoft 365 business license or a deeper software bug requiring official intervention.
Try WPS Office for Seamless Macro and XLSB Support
If Microsoft Excel continues to crash or fail when saving large XLSB files, consider switching to WPS Office. It provides a highly compatible environment for your macro-enabled workbooks, allowing you to edit and save without the frustrating errors or heavy subscription costs.
- 1. Download WPS Office: Download and install the free version of WPS Office from the official website.
- 2. Open Your Workbook: Launch WPS Spreadsheets, click 'File', then 'Open', and select your problematic XLSB file.
- 3. Edit and Save: Make your necessary edits and simply hit 'Save'. WPS Office handles binary workbook saving efficiently, bypassing common Excel errors.

Frequently Asked Questions
Why does Excel struggle to save XLSB files with macros?
Large binary files (XLSB) containing complex VBA macros or multiple external data connections can sometimes experience memory management issues, or they may conflict with third-party COM add-ins during the saving process.
What is the difference between XLSM and XLSB formats?
XLSM is an XML-based macro-enabled workbook format, while XLSB is a binary format. XLSB files are typically smaller in file size and open much faster, making them ideal for massive datasets, though they can occasionally be more prone to specific save errors if add-in conflicts occur.
Can I open and save XLSB files in WPS Office?
Yes, WPS Spreadsheets fully supports opening, editing, and saving Excel Binary Workbook (.xlsb) files, and it also provides robust support for running and editing VBA macros.
Will an Online Repair delete my Excel files?
No, running an Online Repair or Quick Repair for Microsoft 365 only fixes the application's program files and registry entries. It will not delete or modify your personal Excel workbooks or data.




