Cannot open. Corrupt file. Protected View won't let me edit. File is locked. When Excel refuses to work with your workbook — these are the fixes.
⚠️ Before you try any fix, back up your file. Copy the .xlsx to another folder first. Recovery attempts sometimes make things worse — always work on a copy so the original stays safe.
File and workbook errors are the scariest kind because you can't even open the file to diagnose. Below are the 12 most common file-level issues with the fixes that work most often. If nothing here helps, Excel's built-in Recovery Mode has surprising success rates on truly corrupt files.
Top causes: (1) file extension doesn't match content (.xls file renamed to .xlsx or vice versa), (2) file was blocked by Windows because it came from the internet, (3) file corruption during download, (4) unsupported file format.
Cause: Improper shutdown while Excel was writing, disk error, network transfer glitch, or macro that damaged workbook structure. Excel offers "Open and Repair" but success varies.
Cause: Excel treats files from email, internet, or unsafe locations as risky by default. Opens them in read-only Protected View. Not really an error — a security feature.
Cause: Someone else has the file open (in a shared network location or cloud), OR you closed Excel improperly last time and the lock file didn't clear. Look for a hidden file named ~$filename.xlsx in the same folder.
Excel scans the file for damaged structure and attempts to reconstruct valid parts. "Repair" tries to keep as much data as possible. "Extract" gives up on formulas and just extracts values. Extract preserves more data but loses your calculations.
Excel's lock file that indicates the workbook is currently open by someone. Normally deleted automatically when Excel closes. If Excel crashed, the lock stays. Close Excel completely (check Task Manager for any leftover Excel processes) then delete the ~$ file manually.
Windows marks files that came from the internet with a "zone identifier". You can remove it: right-click the file → Properties → check "Unblock" at the bottom → OK. Or add the folder to Excel's Trusted Locations.
Officially: you can't. Excel's encryption is strong enough that brute-force attempts take years. If you set the password recently, check password managers, sticky notes, or common passwords you use. Third-party tools claim recovery but success is low on modern Excel files.
Bloat. Usually from formatted-but-empty rows (formatting extending to row 1,048,576), embedded images at full resolution, or duplicated named ranges. Save as .xlsx then reopen — often shrinks 30-50%. Or use our file size reduction guide.
The Add-in flags workbook bloat, unused cells, and structural issues — the early signs of corruption. Fix them before they become recovery emergencies.
Get the Add-in →