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

Quick answer for advanced users

Open Excel first, then use File > Open > Browse, select the file, click the dropdown next to Open, choose Open and Repair, then hit Repair. If that fails, try Extract.

That's the fastest path. But let's dig into why you're seeing this and what to do when the standard repair doesn't cut it.

Why this error happens

Every .xlsx file is basically a zip archive stuffed with XML files. One of those files gets malformed – a broken formula, a bad style definition, a corrupt chart – and Excel throws its hands up. The file might have been saved over a flaky network drive, or an add-in messed with the internals, or the file crashed during a save. I've seen it happen after a power loss during autosave. The culprits are usually:

• A corrupted pivot cache
• Broken hyperlinks or external references
• Badly formed XML in a custom theme

Don't bother scanning for viruses or reinstalling Office – that's rarely the cause. The file itself is broken.

Step-by-step fix: Open and Repair

1. Open Excel first (blank workbook is fine).
2. Go to File > Open > Browse. Don't double-click the file from Explorer – that bypasses the repair options.
3. Locate your file, but don't double-click. Click once to select it.
4. Find the small dropdown arrow next to the Open button.
5. Choose Open and Repair.
6. When the dialog appears, click Repair first. If that fails, try Extract – it pulls out the data and formulas, though sometimes formatting gets lost.

In my experience, Repair works about 70% of the time. Extract is the backup plan.

If Open and Repair fails: manual XML surgery

When Excel refuses to fix the file itself, you can get your hands dirty. Remember, xlsx is just a zip file. Here's the process:

1. Copy the file and rename it to .zip (e.g., broken.zip).
2. Extract the zip to a folder.
3. Open the xl folder. You'll see files like workbook.xml, sharedStrings.xml, and subfolders for charts, drawings, etc.
4. Look for files that fail to open in a text editor (like Notepad++) – they'll show garbage or error messages.
5. Delete the offending file – usually it's in xl/charts or xl/drawings – and rezip the folder.
6. Rename the zip back to .xlsx and open it.

This is brute force. It works, but you might lose some elements. If you're not comfortable with this, skip it – there's a safer route below.

Alternative fixes that actually work

Use Google Sheets or LibreOffice as a rescue

Sometimes Excel is too strict. Both Google Sheets and LibreOffice Calc are more forgiving with minor XML issues. Upload the file to Google Drive and open with Sheets – it'll often load fine. Then download it as an .xlsx and open in Excel. I've pulled off this trick more times than I can count. Same goes for LibreOffice: just open, save as .xlsx, done.

Check for external links

If the error mentions a specific cell or a broken link, open the file in a text editor (or the zip method above) and search for externalReference in workbook.xml. Remove the offending link. This happens a lot when you've imported data from another workbook that no longer exists.

Turn off hardware acceleration

This sounds unrelated, but I've seen a corrupted display driver cause this error. Go to File > Options > Advanced and uncheck Disable hardware graphics acceleration. Restart Excel. It's a long shot, but it's free to try.

Prevention: stop this from happening again

The best fix is not needing a fix. Here's what I do:

• Save locally first – work on your desktop, then move the file to the network drive. Network saves are a prime corruption source.
• Turn on AutoRecover – set it to save every 5 minutes: File > Options &b> Save. It won't prevent corruption, but you'll have a recent backup.
• Use version history – if you're on OneDrive or SharePoint, right-click the file and pick Version History. You can go back to a pre-corruption version.
• Watch out for add-ins – a buggy add-in can wreck files. Disable ones you don't need.

One last tip: if you see this error on a file you've just received from someone, ask them to re-save it from their end. I've seen files corrupted by email attachments – the transfer just mangles them.

That's the whole playbook. Start with Open and Repair, move to the zip trick, and keep a backup strategy in place. You'll be back in business in ten minutes.