"We found a problem with some content"
Excel opens the file offering to "recover as much as we can". It often repairs by removing things without saying so: a format, a table, sometimes a whole sheet.
What the message says
Part of the file (an XLSX file is a package of compressed files) does not follow the expected format, or is missing. Excel removes it to open the rest.
Why it appears
- A truncated file: interrupted download, cut-off attachment, USB stick pulled out too early.
- A file produced by other software (an ERP export, an online tool) that does not quite follow the format.
- Conditional formats or defined names corrupted by repeated copy and paste.
- An internal reference to a missing part (a drawing, a comment).
Making it go away
- Accept Excel's repair, then read the log it offers: it says what was removed.
- Go back to a previous version of the file if there is one (OneDrive or SharePoint version history).
- Recover the data first, into a new workbook, before any other attempt.
The tool that handles it
Recover a damaged file reads the file part by part, even without its table of contents, sets aside what is unreadable, removes broken references, and returns two files: the repaired workbook when possible, and always the values recovered into a new workbook. The health check then spots what remains fragile.
Frequently asked questions
- Does Excel's repair lose data?
- Sometimes: it removes the parts it cannot read, which may contain values. The repair log says so; read it before saving over the original.