Removed Records: Object from /xl/worksheets/sheet1.xml part

Question

When I open my excel document now I get this report in Word.

Repair Result to ZEMA General Ledger - Jan 20262.xml

Errors were detected in file ’/Users/pjseelhammer/Documents/ZEMA FD 2026 Docs/2, February 2026 Docs/From Rowan Feb 2026/ZEMA General Ledger - Jan 2026.xlsx’

 

Removed Records: Formula from /xl/worksheets/sheet2.xml part

Removed Records: Formula from /xl/worksheets/sheet3.xml part

Removed Records: Formula from /xl/worksheets/sheet4.xml part

Removed Records: Formula from /xl/worksheets/sheet6.xml part

Removed Records: Formula from /xl/worksheets/sheet7.xml part

Removed Records: Shared formula from /xl/worksheets/sheet7.xml part

Removed Records: Formula from /xl/calcChain.xml part (Calculation properties)

 

Answer 1

This message indicates that Excel detected corruption in the workbook and repaired it when opening the file. Specifically, Excel found formulas it could not interpret correctly and removed them from several worksheets. The affected files inside the workbook were sheet2.xml, sheet3.xml, sheet4.xml, sheet6.xml, sheet7.xml, and the calculation chain file calcChain.xml. After the repair, those formulas are gone, so some cells that previously contained formulas may now be blank or contain fixed values.This typically happens when the workbook becomes partially corrupted, when a formula references something invalid, or when a workbook created or edited in another system (for example Google Sheets, LibreOffice, older Excel versions, or export software) writes invalid formula structures into the Excel XML. It can also occur if the file was interrupted while saving or synced through cloud storage during a save.

Open the repaired workbook and check the sheets mentioned in the message. Look for cells that should contain formulas but are now empty or contain values instead. If you have an earlier version of the file, compare those sheets and restore the formulas.

If the file still behaves oddly, the safest repair process is to move the data into a fresh workbook. Create a new Excel file, then copy each worksheet’s values and formulas from the repaired file into the new workbook sheet by sheet. Save the new file under a new name.

You can also force Excel to rebuild the calculation chain, which sometimes clears lingering calculation issues. Open the workbook, press Command + Shift + Option + F9 and then save the workbook.

If you want to check whether formulas were removed in large ranges, you can temporarily show formulas with Command + `. That displays all formulas in cells so you can quickly see where formulas are missing.

---

If the above response helps answer your question, remember to "Accept Answer" so that others in the community facing similar issues can easily find the solution. Your contribution is highly appreciated.

hth

Marcin