Fix Excel Repairs File and Removes Formulas on Mac
Question details
Users experience an issue where Excel for Mac forces a file repair upon opening, resulting in the permanent deletion of formulas, broken tables, and corrupted calcChain.xml.
- Product
- Microsoft Excel
- Device & OS
- macOS
- Scenario
- Opening a macro-enabled workbook (.xlsm) after editing VBA, experiencing a system crash, or encountering a OneDrive synchronization conflict.
- Observed behavior
- Excel displays a repair message stating content was removed (formulas, shared formulas, or calcChain.xml). After the repair, formulas are permanently deleted and the workbook structure is modified.
Immediately create a copy of the corrupted file and store it in a separate local folder before attempting any repairs, as saving the auto-repaired version will permanently overwrite your formulas.
Restore a Previous Working Version via OneDrive or SharePoint
The safest way to recover your formulas is to revert to a cloud version saved before the corruption occurred.
Go to OneDrive or SharePoint online in your web browser and locate your corrupted Excel file.
Right-click the file and select "Version history" from the context menu.
Browse the list of previous versions and select one saved before the VBA edit or system crash occurred.
Click "Restore" to replace the current corrupted file, or "Download" to save a separate working copy locally to your Mac.
Move the File to Local Storage and Update Excel
Syncing conflicts with cloud storage can sometimes trigger XML corruption in macro-enabled workbooks, which can be avoided by testing locally.
Extract Raw Data by Renaming to ZIP
If the file cannot be repaired without losing critical data, you can manually extract the uncorrupted values using the archive method.
Try WPS Office to Prevent Complex File Corruption
If Microsoft Excel continually corrupts your macro-enabled workbooks on Mac, consider switching to WPS Office. It provides a highly compatible, lightweight, and stable environment for your spreadsheet tasks, reducing the risk of unexpected formula deletion.
Frequently Asked Questions
Why does Excel say "Removed Records: Formula / calcChain.xml"?
This error occurs when Excel detects structural corruption in the calculation chain or worksheet XML. It is frequently triggered by saving VBA modifications in macro-enabled (.xlsm) files on Mac, or during a cloud synchronization failure.
Can I stop Excel from automatically repairing my file?
Excel forces repairs when it encounters invalid XML to prevent the application from crashing. You cannot bypass the repair prompt, but you can avoid data loss by opening an older backup or extracting data via the ZIP archive method.
Does this formula removal issue affect Windows users as well?
While highly reproducible on Mac after VBA edits, Windows users can also experience this formula removal issue if the file's XML structure is corrupted due to a severe system crash, power loss, or OneDrive synchronization conflict.
How can I prevent macro-enabled workbooks from corrupting on Mac?
To minimize risk, temporarily turn off AutoSave while writing or modifying VBA code, save your progress manually to a local drive first, and maintain frequent manual backups of complex .xlsm files before closing the application.
