Excel's “We found a problem with some content” warning usually means the workbook needs repair, recovery, or a trust check before it can open cleanly. Start with Excel's built-in recovery tools, then move to older saved copies, Safe Mode, and Office repair when the problem follows more than one file.
Let Excel try its own recovery first
Use this when Excel shows a recovery prompt as soon as you open the workbook. Only continue if you trust where the workbook came from.
Open the workbook directly in Excel and wait for File Recovery mode to appear.
When Excel detects corruption, choose the recovery option shown in the prompt.
After the recovered file opens, use Save As and give it a new file name. That leaves the damaged original available for another attempt.
Use Open and Repair in Excel
When Excel does not recover the file automatically, use the built-in repair command. Go to File, then Open, and select the location and folder that contains the workbook.
In the Open dialog box, select the corrupted workbook. Click the arrow next to Open, choose Open and Repair, then choose Repair.
If Repair cannot recover enough of the workbook, run Open and Repair again and choose Extract Data. This is the fallback when the main repair attempt fails.
Move the file before repairing it
A workbook on a network drive, removable drive, or problem disk can fail because of the storage location. Put a copy on your PC first, then repair that local copy.
- 1.Open File Explorer.
- 2.Copy or move the workbook to Documents or Desktop.
- 3.Open Excel and go to File, then Open.
- 4.Select the local copy of the workbook.
- 5.Choose Open and Repair, then Repair.
Go back to the last saved copy
Try this when the workbook is already open and the problem started before you saved your latest changes. It returns the workbook to the last saved version inside Excel.
In Excel, go to File, then Open.
Double-click the name of the workbook you already have open.
When Excel asks whether to reopen the file, choose Yes. This can discard unsaved changes, so use it when the last saved copy matters more than the current broken state.
Restore a previous OneDrive or SharePoint version
If the workbook is stored in OneDrive or SharePoint, version history may be the cleanest fix. In Excel, open the file, select the file title, choose Version history, open an older version, then select Restore.
You can also use File, then Version History, select a version, and choose Restore. In Office 2016 through 2021, the path may appear as File, then History.
From OneDrive on the web, sign in, select the file, right-click it, choose Version history, select the ellipses next to the version you want, and choose Restore. Personal OneDrive keeps version history for 30 days, while work or school retention can depend on admin settings.
Recover an unsaved workbook
Use this when the damaged workbook replaced a recent working copy or Excel closed before you saved a good version. In Excel, go to File, then Info, then Manage Document, and choose Recover Unsaved Workbooks.
Select the available file, choose Open, then use the bar at the top of the file to select Save As. Save it with a new name so it stays separate from the workbook that triggered the error.
If this method fails, try Version history for OneDrive or SharePoint files, or use Restore previous versions in Windows if File History was enabled before the problem occurred.
Open the workbook with fewer startup problems
This is useful when Excel crashes, freezes, or fails before you can reach the repair tools. Office Safe Mode starts Excel with fewer startup features, which helps when the issue involves add-ins, extensions, corrupted resources, registry problems, or templates.
Find the Excel shortcut icon, press and hold Ctrl, then double-click the shortcut.
When Windows asks whether to start Excel in Safe Mode, choose Yes.
You can also right-click Start, choose Run, type excel /safe, and select OK.
Once Excel opens, try the workbook again with File, then Open.
Check Protected View and blocked files
Use these checks only when you trust the workbook's source and contents.
- 1.If Excel opens the file in Protected View with a yellow message bar, select Enable Editing.
- 2.If a red Protected View message reports a file-validation problem, go to File and choose Edit Anyway.
- 3.For a downloaded workbook on Windows, right-click the file in File Explorer, choose Properties, open the General tab, select Unblock, then choose Apply and OK.
- 4.For a trusted folder, go to File, Options, Trust Center, Trust Center Settings, Trusted Locations, then Add new location.
- 5.If Excel blocks an older or specific file type, review File, Options, Trust Center, Trust Center Settings, then File Block Settings.
Repair or update Office when every file struggles
If Excel has trouble with multiple workbooks, repair the Office installation. On Windows 11, right-click Start, choose Installed apps, select your Microsoft 365 or Office product, choose the ellipses, then Modify, Online Repair, and Repair.
On Windows 10, right-click Start, choose Apps and Features, select your Microsoft 365 or Office product, then choose Modify. For Click-to-Run installs, choose Online Repair and Repair; Quick Repair is also available.
Update Office from Excel by going to File, Account, Product Information, Update Options, then Update Now. On Mac, open Excel and use Help, then Check for Updates, or update Office apps through the Mac App Store's Updates page.
On a work or school device, local Trust Center choices may be controlled by an administrator. Ask your IT team if Protected View, Trusted Locations, Macro Settings, External Content, or File Block Settings are being managed for your account.
Frequently Asked Questions
What does Excel mean by “We found a problem with some content”?
Excel is warning that the workbook has content it cannot open normally. The most direct fix is to use Open and Repair, then try Extract Data if Repair fails.
Will Open and Repair delete my workbook?
Save any recovered result with a new name. That keeps the original damaged workbook available in case you need another recovery attempt.
Why does the same workbook open in desktop Excel but not Excel for the web?
Excel for the web can block editing when a workbook uses unsupported features such as VBA projects or XML maps. Use Edit in Excel, Open in Excel, or Edit a Copy when Excel for the web offers those options.
Should I edit the XLSX file's internal XML files?
No. Use supported recovery options first: Open and Repair, Extract Data, version history, unsaved workbook recovery, Safe Mode, and Office repair.
