Excel 'We found a problem' error when saving – real fix

Yeah, that error stinks. You've been working on a spreadsheet for an hour, hit Save, and Excel tells you it found a problem in the file. Then it offers to recover whatever it can, but you're still stuck. Let's fix it.

The fastest fix that works 90% of the time

Don't bother with Microsoft's generic repair tool yet. The real fix is simpler: you're going to strip out the offending content by saving the file as a different format, then saving it back.

1. Open Excel (if it crashed, restart it).
2. Go to File > Open > Browse.
3. Find the problem file, but don't double-click it. Instead, click once to select it, then click the dropdown arrow next to the Open button (not the button itself).
4. Choose Open and Repair from the dropdown.
5. In the dialog, click Repair. Excel will try to fix the file. If that fails, try Extract Data (it'll strip formatting and formulas, but you'll keep the raw data).
6. After repair, immediately go to File > Save As and pick Excel Workbook (*.xlsx) format. Save it with a new name like myfile_fixed.xlsx.
7. Close Excel, reopen the new file, and try saving again. If it works, you're done.

What to expect: After clicking Repair, you'll see a message saying "Excel repaired the file." If you clicked Extract Data, you'll get a new workbook with the data but no charts or formulas. Either way, the new .xlsx file should save without the error.

Why this happens

The error comes from Excel's internal consistency check. When you save, Excel scans the XML inside the .xlsx file (yes, it's a ZIP of XML files). If it finds something that doesn't match its schema – like a corrupted cell reference, a broken conditional formatting rule, or a leftover bit from a crashed add-in – it triggers the error.

Most of the time, the problem sits in one of these three places:

• Conditional formatting rules that overlap or point to deleted ranges.
• Named ranges that reference cells you deleted.
• ActiveX controls or old COM add-ins that leave behind broken references.

Opening and repairing the file forces Excel to rebuild the XML structure, stripping out those broken bits. Saving as a new file gives you a clean start.

When the quick fix doesn't work

Sometimes the error comes back even after a repair. This usually means the corruption is deeper – maybe in a chart's data series or in a PivotTable cache. Here's the next step.

1. Open the repaired file.
2. Go through each sheet and look for worksheets that have conditional formatting (Home tab > Conditional Formatting > Manage Rules). If you see rules that reference rows or columns that don't exist anymore, delete those rules.
3. Check for named ranges (Formulas tab > Name Manager). Sort by Scope. Any range that shows #REF! in the Refers To column – delete it.
4. If the file still errors, copy all the data (not the sheets) into a brand new workbook. Do this: open a blank workbook, right-click on the first sheet of the broken file, choose Move or Copy, check "Create a copy," and in the To book dropdown, select the new blank workbook. Repeat for each sheet. Then save the new workbook.

This copy-the-sheets trick works because it re-creates the internal XML without carrying over corruption from the original workbook structure.

Less common causes that fool people

• Print area references. Sometimes a print area points to a range that's been deleted. Go to Page Layout tab > Print Area > Clear Print Area, then set it fresh.
• Shared workbook features. If the file was shared (Review tab > Share Workbook), turn sharing off. That feature hasn't been updated since Excel 2010 and is known to cause corruption on save.
• External links. If the file links to other workbooks you no longer have, those broken links can trigger the error. Go to Data tab > Edit Links, break any that show errors.

How to stop this from happening again

Prevention isn't complicated, but you have to be consistent.

• Save a backup copy every hour. Seriously. Use File > Save As > Tools (next to Save button) > General Options > Always create backup. This creates a .xlk file that's a snapshot of your previous save.
• Don't let Excel crash without saving. If Excel freezes, wait a minute before force-closing. Force-closing during an autosave can corrupt the file.
• Avoid large conditional formatting sets. More than 50 rules in a workbook increases crash risk. Use a macro to clean them up monthly.
• Use .xlsb format for massive workbooks. Binary workbooks (.xlsb) are less prone to this specific error because they don't use XML. Only switch if you're comfortable with a slightly less compatible format.

One last tip: if you see this error repeatedly on the same file from different computers, the file itself is likely corrupted beyond repair. In that case, extract the data using the Move or Copy method above and rebuild the workbook from scratch. It's painful, but it's faster than fighting it for days.