Opening a spreadsheet only to be greeted by “We found a problem with some content in filename.xlsx” is every Excel user’s nightmare — especially when the file holds hours of work. Excel shows this warning when it detects something unreadable inside the workbook’s structure, then offers to recover as much as it can. Clicking Yes sometimes saves the day, but often the error returns every time you open the file, or parts of the workbook go missing. This guide explains why the Excel “we found a problem with some content” error happens and gives you six proven ways to fix the file properly. For Excel’s other notorious startup hang, see our Excel “waiting for OLE action” error guide.
What Causes the “We Found a Problem With Some Content” Error?
Modern Excel files (.xlsx) are really ZIP archives full of XML parts describing worksheets, styles, and formulas. If any of those parts gets damaged — a truncated save after a crash, a power cut mid-save, a bad sector on the disk, or a glitch while downloading or emailing the file — Excel detects the inconsistency on open and raises this warning. The file is not necessarily ruined; Excel is telling you it found something it cannot parse.
Beyond outright corruption, the error is frequently triggered by problematic content rather than damage: third-party add-ins injecting invalid XML, features from a newer Excel version that the current one cannot understand, broken external links, or files downloaded from the internet that Windows has blocked. Macros and ActiveX controls from untrusted sources are repeat offenders as well.
How to Fix the Excel Content Error
Fix 1: Use Open and Repair
Excel’s built-in Open and Repair command is designed exactly for this situation. It scans the workbook’s internal structure, discards the unreadable parts, and rebuilds what it can. Always work on a copy of the file first.
- Make a copy of the damaged file in File Explorer (right-click > Copy, then Paste) and work on the copy.
- Open Excel, then go to File > Open > Browse and navigate to the copied file. Do not open it from the Recent list.
- Click the file once to select it, then click the small arrow next to the Open button and choose Open and Repair.
- Click Repair to recover as much of the workbook as possible.
- If Repair cannot recover the data, repeat the process and choose Extract Data instead, which pulls out values and formulas.
- Save the recovered workbook under a new name via File > Save As.
Fix 2: Unblock the File
Files downloaded from the internet or received as email attachments are often flagged by Windows as untrusted, which can trigger content warnings in Excel. Unblocking takes ten seconds.
- Close Excel completely.
- In File Explorer, right-click the problem file and choose Properties.
- On the General tab, look at the bottom for a Security notice saying the file came from another computer.
- Tick Unblock, click Apply, then OK.
- Reopen the file in Excel and check whether the warning is gone.
Fix 3: Disable Add-ins
Add-ins can inject invalid content into workbooks or interfere with how Excel reads them. Testing with add-ins off quickly shows whether one is to blame.
- Open Excel and go to File > Options > Add-ins.
- Set the Manage dropdown to Excel Add-ins, click Go, and uncheck everything. Click OK.
- Repeat with the dropdown set to COM Add-ins and disable those too.
- Close and reopen Excel, then open the problem file. If the error is gone, re-enable add-ins one by one to identify the culprit.
Fix 4: Save the File in a Different Format
Saving the workbook as the binary .xlsb format (or a clean .xlsx) forces Excel to rewrite the entire file structure, which often drops whatever invalid part was causing the warning.
- Open the file and click Yes on the recovery prompt so Excel loads what it can.
- Go to File > Save As > Browse.
- Change Save as type to Excel Binary Workbook (*.xlsb) and save with a new name.
- Close and reopen the new file. If the warning is gone, you can keep working in .xlsb or save back to .xlsx with another Save As.
Fix 5: Copy the Sheets Into a Fresh Workbook
When repair tools stall, manually moving your data into a brand-new workbook leaves the damaged structure behind. It is tedious for large files but extremely reliable.
- Open the damaged file (click Yes on the recovery prompt) and also open a new blank workbook.
- In the damaged workbook, right-click a sheet tab and choose Move or Copy.
- In the dialog, choose the new workbook in the To book dropdown, tick Create a copy, and click OK.
- Repeat for each sheet. If one particular sheet triggers errors during copying, recreate that sheet’s content manually — it likely holds the corruption.
- Save the new workbook and verify it opens cleanly.
Fix 6: Open Excel in Safe Mode and Repair Office
If the error appears with many different files, the problem is Excel itself rather than one workbook. Safe Mode and an Office repair address that.
- Press Win + R, type excel.exe /safe, and press Enter. Open the problem file — if it opens cleanly, an add-in or startup setting is at fault (see Fix 3).
- If Safe Mode does not help, close all Office apps and open Settings > Apps > Installed apps.
- Find Microsoft 365 or Microsoft Office, click the three dots, and choose Modify.
- Run Quick Repair first; if the error persists, run Online Repair.
- Restart your PC and test the file again.
Microsoft’s official walkthrough for damaged workbooks: Repairing a corrupted workbook.
How to Prevent This Error
- Save your work frequently, and enable AutoRecover under File > Options > Save.
- Never pull out a USB drive while an Excel file on it is still open — use Safely Remove Hardware.
- Keep workbooks stored on your local drive or OneDrive rather than on aging USB sticks or network shares.
- Keep Excel and Windows updated so you always have the latest file-format fixes.
- Be cautious with macros and add-ins from untrusted sources; disable any you do not actively use.
- For critical spreadsheets, keep versioned backups — File > Save a Copy with a date in the name takes seconds.
FAQs
What does “We found a problem with some content” actually mean?
It means Excel detected unreadable or invalid parts inside the workbook file — damaged XML, unsupported features, or blocked content. Excel offers to strip out the bad parts and recover the rest, which is why you should always let it attempt recovery and then save the result under a new name.
Will clicking “Yes” delete my data?
It can remove the unreadable portions, which sometimes includes formatting, charts, or formulas tied to the damaged parts. That is why you should always work on a copy: click Yes on the copy, inspect what survived, and keep the original untouched until you are satisfied.
Why does the error come back every time I open the file?
Because the underlying damage is still in the file — dismissing the prompt does not fix it. You need to actually repair the structure with Open and Repair, re-save in a new format, or move the content to a fresh workbook as described above.
Can this error be caused by a virus?
Rarely directly, but malware can damage files on disk, and antivirus quarantining part of a file mid-save can leave it truncated. If corruption keeps recurring across many files, run a full antivirus scan and check your drive health.
Is the .xlsb format safe to use long-term?
Yes. The Excel Binary Workbook format is a fully supported Microsoft format that is often smaller and faster than .xlsx. The only caveat is that some third-party tools that parse .xlsx XML cannot read .xlsb — for pure Excel use, it is completely fine.
Conclusion
The “we found a problem with some content” error is Excel telling you a workbook’s internal structure has damage or untrusted content — not that your data is gone. Open and Repair recovers most files, unblocking fixes the downloaded-file cases, and moving sheets to a fresh workbook handles the stubborn ones. Pair the fix with AutoRecover and regular backups, and a corrupted spreadsheet will never again mean a lost day’s work.
