Fix Excel 'We found a problem with some content' error

Yeah, that message makes your stomach drop. You're just trying to open a spreadsheet and Excel throws that passive-aggressive error. Calm down. Most of the time you can fix it in under five minutes without any fancy software.

The Quick Fix: Manual Repair

The culprit here is almost always a corrupted XML file inside the .xlsx container. Excel is picky about that stuff. The error message even gives you a chance to click "Yes" to recover, but that doesn't always work. When it doesn't, you get your hands dirty.

Make a copy first. You don't want to mess with the original. Copy the file to your desktop.
Rename the copy from filename.xlsx to filename.zip. Windows will ask if you're sure. Say yes.
Right-click the zip and choose "Extract All". Extract to a folder.
Go into the folder. Find the xl folder, then worksheets. You'll see files like sheet1.xml, sheet2.xml, etc.
Open each .xml file with WordPad. Not Notepad — WordPad handles the formatting better. Right-click the file, choose "Open with", then WordPad.
Scan the beginning of the file. Look for a line that has weird characters, extra spaces, or something that just looks off. Common culprits: <c r="A1"> with missing closing tags, or garbage characters like â€‹ (invisible Unicode).
Delete the offending element. If you see a cell reference like <c r="A1"> and the closing tag is missing, delete the whole opening tag. If you see something like <c r="A1"><v>123</v></c> but one of the tags is misspelled, fix it.
Save the file as .xml — WordPad might try to save as RTF. You have to manually type the .xml extension and choose "All Files" as the file type.
Now select everything inside the extracted folder (all files and folders), right-click, and choose "Send to" -> "Compressed (zipped) folder".
Rename that new zip back to .xlsx.
Open it in Excel. If it opens, you're golden. If not, try the next sheet file. Repeat until you find the bad one.

That sounds like a lot of steps, but it's mechanical. You're just finding and removing the broken bit. I've done this dozens of times and it works maybe 80% of the time.

Why This Works

An .xlsx file is basically a zip archive with a bunch of XML inside. Each sheet is its own XML file. When Excel saves, it writes well-formed XML. But sometimes things go sideways — a crash during save, a bad macro, or even a sync tool like OneDrive messing with the file while it's open. That leaves a tiny bit of invalid XML. Excel tries to parse it, hits the error, and gives up. By extracting and inspecting the XML manually, you're bypassing Excel's strict parser and fixing the actual cause.

Less Common Variations

1. The error appears on every file you open

If this happens on every Excel file, not just one, then the problem isn't the file — it's Excel itself. The culprit is usually a broken add-in or a corrupted Excel profile. Try starting Excel in Safe Mode: hold Ctrl while clicking the Excel icon. If it opens fine, disable add-ins via File -> Options -> Add-Ins -> Manage COM Add-ins. If that doesn't fix it, delete the Excel key in the registry:

HKEY_CURRENT_USER\Software\Microsoft\Office\16.0\Excel

Back it up first, then delete it. Excel will rebuild it on next start. That's a nuclear option, but it works.

2. The file opens but some data is missing

That's a partial corruption. You might see the error but then Excel recovers and opens the file. Your charts or formulas might be gone. Don't trust that recovery. Use the zip method above and compare the XML to a known-good copy. Usually you'll find a row or column that's been truncated. Fix that XML and you're back in business.

3. The error says "We found a problem with some content" and offers to recover, but recovery fails.

Same fix, just more corruption. Do the zip extraction, and if you can't spot the issue visually, look for XML files that are larger than the others — they're more likely to have the problem. Also check the sharedStrings.xml file. That stores all text strings. If that's corrupted, you'll see garbled text or missing values.

Prevention

You'll never completely avoid this, but you can cut the odds.

Don't save files while OneDrive or Dropbox is syncing. Wait for the sync icon to settle.
Use Excel's built-in backup. File -> Options -> Save -> Always create backup. It's a no-brainer.
Save as .xlsb instead of .xlsx. The binary format is more resilient. You lose a little compatibility, but you'll rarely see this error.
Keep a version history. If you're using SharePoint or OneDrive, turn on versioning. If you're not, copy the file to a second location every time you make major changes.

That's it. Now go fix your file. If you get stuck, drop the file into the comments and I'll take a look.