Quick answer for advanced users: Right-click the file > Properties > check 'Unblock' > OK. Reopen Excel. If that fails, go to File > Open > Browse, select the file, use the Open dropdown arrow, choose 'Open and Repair'. That's the core fix. Skip the rest if that works.
Why This Error Happens
This isn't a random corruption scare. It's Excel's safety lock tripping. When you download a .xlsx file from email, SharePoint, or a web download link, Windows slaps a Zone.Identifier alternate data stream on it. That stream tells Office apps 'this file came from the internet zone' — and Office defaults to blocking it. I've seen this daily with clients pulling invoices from client portals or shared drive links. The exact message usually reads: "Excel cannot open the file 'filename.xlsx' because the file format or file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file." It's misleading — the file is fine, just locked.
Step-by-Step Fix
- Unblock the file from Properties. Right-click the file in File Explorer. Choose Properties. On the General tab, look at the bottom. If there's a Security section saying 'This file came from another computer and might be blocked to help protect this computer', check the 'Unblock' box. Click Apply then OK. That strips the Zone.Identifier. Reopen Excel and the file.
- If no Unblock option shows up — that happens with files already extracted from a ZIP or copied from a network share. Instead, open Excel first (empty workbook). Go to File > Open > Browse. Navigate to the problem file. Click once on it to select it. Don't double-click. Look at the Open button — it has a little dropdown arrow beside it. Click that arrow and choose 'Open and Repair'. Excel will try to rebuild the file. Usually picks up the data even if the structure is busted.
- Still broken? Force open in Protected View. In the same Open dialog, click the Open button's dropdown and choose 'Open in Protected View'. Excel will open it read-only but you can then click Enable Editing in the yellow bar. That bypasses the block but keeps the file safe. Then immediately save it to a new name on your local drive.
Alternative Fixes When the Main One Fails
If unblocking and repair don't cut it, try these in order:
- Open with LibreOffice. LibreOffice Calc handles Office files differently. It often opens 'corrupted' Excel files that Excel itself won't touch. Open the file in Calc, then export it back as .xlsx. I've had to do this twice this year for clients with 10-year-old budgets.
- Rename the extension. Change .xlsx to .zip. Right-click it, rename, and hit Yes to the warning. Now extract the contents. Inside you'll see folders like xl, _rels, [Content_Types].xml. Navigate to xl > workbook.xml. Open that in Notepad. If the XML is garbled, the file is truly corrupt. If it looks readable, you can sometimes rebuild by zipping the folder back, renaming to .xlsx, and opening. Rarely works, but costs nothing.
- Use a third-party repair tool. Stellar Repair for Excel or DataNumen Excel Repair can salvage data when everything else fails. They're not free, but if the file is worth a few hundred bucks, it's worth the $30 or $60. I recommend Stellar — it's saved a client's payroll file once.
- Last resort: recover from AutoRecover. In Excel, go to File > Info > Manage Workbook > Recover Unsaved Workbooks. This only works if Excel was open when the file was last saved. Check the AutoRecover file location: File > Options > Save > AutoRecover file location. Copy that path into File Explorer and look for .xlsb backup files.
Prevention Tip
Stop the problem before it happens. When you download an Excel file from the internet, right-click it and unblock before you open it. If you're the one sharing files, zip them before sending. Zipping strips the Zone.Identifier automatically. Also, in Excel, go to File > Options > Trust Center > Trust Center Settings > Protected View. Uncheck 'Enable Protected View for files originating from the internet' — but only if you're the only user on that machine. For a shared computer, leave it checked.
One more thing: if you're opening files from a network drive and getting this, it's the same Zone.Identifier problem. Map the drive as a local path or use the workaround: copy the file to your desktop first, then open. Always.