Excel throws “The file is corrupt and cannot be opened” most often for files you downloaded or received as email attachments. The file itself is usually fine. This error is distinct from “the file format or extension is not valid” or “we found a problem with some content,” which need their own fixes. Work through this sequence: unblock the file, adjust Protected View, then run Open and Repair. One of them nearly always solves it.
Unblock the File After Download or Email
Windows tags files from the internet or email as potentially unsafe. That security flag triggers the corrupt-file error on a perfectly valid workbook. Remove the flag.
- Find the file in File Explorer or on your desktop.
- Right-click it and choose Properties.
- On the General tab, tick the Unblock checkbox if you see it.
- Click OK.
Open the file. This step alone fixes most downloads and attachments. No Unblock checkbox means Windows did not flag the file. Move on.
Adjust Protected View Settings
Protected View opens files from untrusted sources in a restricted mode. It sometimes mislabels a file as corrupt, particularly after a download or email attachment. Test whether it is the cause.
Turn Off Protected View Temporarily
Switch off all three Protected View options, open the file, then switch them straight back on. Do this only for a file you trust.
- In Excel, go to File > Options > Trust Center > Trust Center Settings > Protected View.
- Uncheck all three boxes: files from the internet, files in unsafe locations, and Outlook attachments.
- Click OK and restart Excel.
If the file opens, Protected View was the culprit. Re-enable all three checkboxes immediately. It is a security layer you want active.
Add a Trusted Location
Rather than disabling Protected View globally, exempt a single folder. Files placed there bypass the restriction without weakening security elsewhere.
- Go to File > Options > Trust Center > Trust Center Settings > Trusted Locations.
- Click Add new location and browse to the folder holding the file.
- Select it and click OK.
Move the problem file into that folder and open it. This targets the exemption.
Use Open and Repair for Genuine Damage
If unblocking and Protected View changes do nothing, the workbook may actually be damaged. Excel has a built-in repair tool that recovers data from many corrupted files.
- Open Excel to a blank workbook.
- Go to File > Open and select the file.
- Click the arrow beside the Open button.
- Choose Open and Repair.
If the repair succeeds, save the file under a new name. If it fails, you see the corrupt-file message again. Try the next tactic.
Check the File Signature
The error sometimes means the file extension does not match the actual format. An .xlsx file is a ZIP package; its first bytes are “PK” (hex 50 4B). An older .xls file begins with D0 CF 11 E0. A mismatch makes Excel reject the file.
Check the signature with a hex editor, or rename the extension to .zip and open it in File Explorer. A folder structure full of XML files confirms a valid .xlsx. Anything else suggests a different format.
Rename the extension to match the real format. If it is actually an .xls wearing an .xlsx extension, switch it to .xls and open it. This is less common than the Protected View issue, but it happens.
Try Excel for the Web or Google Sheets
Desktop Excel still refusing? An online spreadsheet app will open many files that the desktop version rejects. It is a fast way to learn whether the file or your local installation is at fault.
- Upload the file to OneDrive or Google Drive.
- Open it in Excel for the web or Google Sheets.
- If it opens, save a copy in a compatible format and bring that copy back to desktop Excel.
Opens online but not on the desktop: the problem is a local setting or minor corruption the online tool handles. Fails online too: the file is probably seriously damaged.
When All Else Fails Recover Data
None of the above worked. The file is too damaged to open normally. You can still try to pull the data out.
- Check for backup versions. File History or a previous-version feature may have an earlier copy.
- Run Open and Repair again and choose “Extract data” if the option appears. It is not always offered.
- A third-party recovery tool can help. Use only one from a reputable vendor.
If the file is critical and cannot be recovered, recreate it from memory or other copies. Keep backups of important workbooks going forward.