How to Fix Excel Removing Named Formulas with Backslash in XLSB Workbooks
Question details
Users need a way to stop Excel from automatically repairing or removing named formulas that contain a backslash when working with XLSB binary workbooks.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Closing and reopening an XLSB (Excel Binary Workbook) file that contains specific named formulas utilizing a backslash prefix.
- Observed behavior
- The named formulas function correctly while creating and editing the document, but upon saving, closing, and reopening the XLSB workbook, Excel automatically repairs the file and removes the formulas.
Before troubleshooting, ensure that you have created a backup copy of your original XLSB workbook to prevent accidental data loss during the repair or migration process.
Transfer Worksheet Data to a New Workbook
Transferring your data to a fresh workbook can resolve issues caused by underlying file corruption in the original XLSB file.
Often, workbook corruption is tied to a specific file rather than the Excel application itself. By migrating your data to a new file, you bypass the hidden corruption triggers that cause Excel to repair your named formulas.
Open Excel, create a new blank workbook, and define a simple named formula containing a backslash. Save and reopen it to verify if the issue is global or file-specific.
If the new workbook works fine, open your corrupted original XLSB file. Select the worksheet contents and press Ctrl+C to copy your data.
Paste the copied data into the new workbook using Ctrl+V. Recreate your named formulas, and save the new file.
Replace the Backslash Prefix in Named Formulas
Changing the naming convention of your formulas avoids compatibility bugs specific to the backslash character in binary workbooks.
Update Microsoft Office to the Latest Version
Installing the latest Office updates can patch known bugs related to XLSB file handling and formula repairs.
Use WPS Office to Seamlessly Handle Complex Spreadsheets
If Microsoft Excel continues to corrupt or repair your binary workbooks, consider switching to WPS Office. It provides a lightweight, highly compatible spreadsheet environment that handles complex named formulas and various file formats without unexpected data loss.
- 1. Download and Install: Download WPS Office for free from the official website and complete the quick installation.
- 2. Open Your Spreadsheet: Launch WPS Spreadsheets, click 'Open', and select your problematic workbook to load your data safely.
- 3. Manage Formulas Securely: Edit and manage your named formulas using the familiar Name Manager, and save your work without fear of sudden automatic repairs.

Frequently Asked Questions
Why does Excel remove named formulas containing a backslash in XLSB files?
This is often due to a bug in how Excel's binary parsing engine interprets certain special characters during the save process. The backslash may trigger strict syntax checks upon reopening, causing Excel's automatic repair tool to delete the 'invalid' formula.
What is the difference between an XLSB and an XLSX file?
An XLSX file is built on the XML format, whereas an XLSB file is a binary workbook format. XLSB files are optimized for faster loading and saving of extremely large datasets, but they can occasionally encounter specific corruption bugs that XML formats bypass.
Can I recover the deleted formulas from a repaired Excel workbook?
Unfortunately, once Excel automatically repairs the workbook and removes the formulas, they cannot be restored from that specific file state. You must recover them manually by opening a previous backup copy of the workbook.




