We Found a Problem With Some Content in Excel

The full message reads: "We found a problem with some content in [file name]. Do you want us to try to recover as much as we can? If you trust the source of this workbook, click Yes."

An .xlsx file is a ZIP archive of XML files: one per sheet, plus shared text, styles, charts, and lists that tie them together. Excel shows this message when one of those parts is cut short, written in a way Excel won't accept, or points at something that isn't there.

Yes or No

• Yes lets Excel repair the workbook. It then shows what it removed or repaired, and offers a log file with the details.
• No closes the message without opening the file. Nothing is deleted.

Copy the original file before you click either. Once you save Excel's repaired version over it, what Excel dropped is gone.

After Excel repairs the workbook, it shows a list such as "Removed Records: Formula from /xl/calcChain.xml part". Each line names a part of the file:

• /xl/calcChain.xml: Excel's list of formula cells in calculation order. Excel rebuilds it, and your formulas are still there. This one is harmless.
• /xl/worksheets/sheet1.xml: a sheet. Check that sheet for missing cells, formulas or formatting.
• /xl/sharedStrings.xml: the text used in cells. If it was removed, cells may show as empty where text used to be.
• /xl/styles.xml: number formats, fonts and fills. Data is safe, but formatting may change.
• /xl/drawings/ or /xl/charts/: pictures, shapes and charts. These may be gone after the repair.
• Conditional formatting or data validation: rules Excel couldn't read. The cells keep their values.

The number in a sheet's part name doesn't always match its tab position, especially in files written by other programs. If you aren't sure which sheet it is, check them all.

Work on a copy of the file. Menu names can differ a little between Excel versions.

1. Click Yes and check the list of what Excel removed. If only calcChain.xml is named, save the workbook and you are done.
2. Open and Repair. In Excel, select File, then Open. Select the workbook once, select the arrow next to Open, then Open and Repair. Select Repair, or Extract Data if Repair fails.
3. Repair it in the browser. Drop the original file into the tool at the top of this page. It names each broken part, fixes what it can and keeps the rest of the workbook as it was. Open the repaired copy in Excel.

If the message comes back every time you save, a formula, a chart or a rule is being written wrong each time. Note which part Excel names, find that sheet or chart, and rebuild it in a new workbook.

• A save, copy or download that stopped early. The end of the ZIP archive holds its index, so a cut-off file loses its index first.
• A file written by another program. Exports from websites, accounting tools, scripts and AI assistants build .xlsx files with their own code. A small slip, such as a stray & or a sheet listed but missing, is enough for Excel to complain.
• A sync conflict in a cloud folder that left a mix of two versions.
• A newer feature opened in an older Excel. Some functions and chart types are unknown to older versions, which may treat them as damage.