You double-click your spreadsheet and nothing happens. Or Excel launches to a blank grey window. Or a warning pops up about the format not matching the extension, and your data stays out of reach.
The good news: most "Excel won't open my file" problems trace back to a handful of known causes, and almost all of them have an official fix. Some are one-click toggles; others recover data from a damaged workbook.
Work through the fixes below in order. They are arranged quickest and most common first, so you can stop as soon as your file opens.
Open the File From Inside Excel First
Before changing any settings, try the fastest workaround. Instead of double-clicking the file in File Explorer, open Excel on its own, then load the workbook from within the app.
- 1.Launch Excel from the Start menu or taskbar.
- 2.Select File > Open.
- 3.Browse to the file and open it directly.
If the file opens this way but double-clicking does not, the problem is with how Windows hands the file to Excel, not with the file itself. The next two fixes address that directly.
Turn Off the Ignore DDE Setting
This is the single most common reason a double-clicked file does nothing or opens to a blank screen while Excel itself launches fine. Windows sends Excel a Dynamic Data Exchange (DDE) message when you double-click a file; if Excel is set to ignore those messages, it never loads the workbook.
- 1.Open Excel and select File > Options.
- 2.Select the Advanced category.
- 3.Scroll down to the General section.
- 4.Clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box.
- 5.Select OK, then double-click your file again.
With that box checked, double-clicking silently breaks even though Excel opens normally. Unchecking it usually restores the open-on-double-click behavior immediately.
Reveal a Hidden Sheet or Refresh the Window
Sometimes the file does open, but the window is blank, so it looks like nothing loaded. A blank screen is often not corruption at all. A sheet or window may have been saved hidden, or the window simply needs a refresh.
First, check for hidden sheets. Go to the View tab, select Unhide, choose a workbook from the list, and select OK.
If that does not help, refresh the window. Select the minimize button at the top-right of the Excel window, then right-click Excel in the task tray and select your spreadsheet (or double-click the Excel icon) to maximize it. Your data may reappear.
Clear the "Format Doesn't Match Extension" Warning
If Excel warns that "the file name extension doesn't match the actual file format," the file's real format differs from what its extension claims. This happens with a renamed file, or sometimes with a maliciously disguised one.
Decide whether you trust the source. Do not open a file you cannot verify, because the warning can indicate a renamed file meant to trick you into opening it.
- 1.If you trust the file, select Yes to open it.
- 2.Once it opens correctly, re-save it in the right format: File > Save As and choose the matching format and extension.
For an email attachment that triggers this every time, ask the sender to resend it as an Excel Binary Workbook (*.xlsb) or Excel 97-2003 Workbook (*.xls), or save the attachment to your computer first before opening it. If the file turns out to be genuinely damaged, use the Open and Repair steps further down.
Exit Protected View or Unblock the File
A file from the internet, an email attachment, or an unsafe location may open in Protected View, which looks like the file did not open for editing. The fix depends on the colored Message Bar you see.
- Yellow Message Bar: select Enable Editing.
- Red Message Bar (a file-validation issue): if you trust the file, select File > Edit Anyway. Microsoft warns this type of file may harm your computer, so only do this when you are confident of the source.
To change which files trigger Protected View, go to File > Options > Trust Center > Trust Center Settings > Protected View and adjust the check boxes for internet files, unsafe locations, or Outlook attachments.
You can also unblock a downloaded file at the Windows level. Right-click the file, choose Properties, and at the bottom of the General tab select the Unblock check box, then select OK.
Repair a Corrupted Workbook With Open and Repair
If the file is damaged, Excel may start File Recovery mode automatically and try to reopen and repair it. If that does not happen, run the repair manually.
- 1.On the File tab, select Open.
- 2.Browse to and select the corrupted workbook in the Open dialog box.
- 3.Click the arrow next to the Open button, then select Open and Repair.
- 4.Select Repair to recover as much workbook data as possible.
- 5.If Repair cannot recover your data, select Extract Data to pull out values and formulas instead.
If Open and Repair still fails, there are official fallback methods. Set calculation to manual before opening: create a new blank workbook, go to File > Options > Formulas, select Manual under Calculation options, then open the corrupted file. You can also convert through the SYLK format: open the file if you can, use File > Save As and choose SYLK (Symbolic Link) (*.slk), reopen the .slk file, then save it back to an Excel Workbook (*.xlsx) under a new name. Note that SYLK saves only the active sheet, so a multi-sheet workbook will lose its other sheets.
Start in Safe Mode and Disable Add-Ins
A faulty or conflicting add-in can stop files from loading. To isolate it, start Excel without add-ins.
- 1.Open Run (Windows key + R), type Excel /safe, and select OK.
- 2.If Excel opens in safe mode, go to File > Options > Add-ins.
- 3.In the Manage box, select COM Add-ins and click Go.
- 4.Clear the check boxes, click OK, then close and restart Excel normally.
If the problem continues, repeat the process but select Excel Add-ins in the Manage list, since Excel add-ins and COM add-ins live in different places and both need checking. When diagnosing a blank-screen case specifically, disable add-ins one at a time, restarting between each, so the last one you turned off before it worked is the culprit. Also confirm your antivirus software is up to date and disable any "Excel integration" feature it adds.
Fix File Associations, Repair Office, or Confirm Format Support
If double-clicking opens the wrong program (or none), the file association may be broken, or multiple Office versions may be fighting over the file type. Reset the default app in Windows 10 or 11: copy the file to your desktop, right-click it, and select Properties. On the General tab, note the file type, then select Change > More apps, choose the correct Office app, check Always use this app, and select OK. You can also set defaults through Control Panel > Programs > Default Programs, entering the file extension and choosing the right application.
If several Office versions are installed and conflict, a repair alone may not stick until you remove the extra one through Control Panel > Uninstall a program, then restart.
When the Office installation itself is damaged, repair it. Right-click the Start button, select Installed apps (Windows 11) or Apps and Features (Windows 10), select your Microsoft 365 or Office product, and click Modify. Choose Quick Repair first (it works offline and replaces corrupted files), or Online Repair for a more thorough fix that reinstalls Office and needs an internet connection. Restart afterward if prompted.
If you are on a phone or tablet, the issue may simply be format support. The mobile and Windows Mobile builds of Excel support a narrower set of file types than the desktop app. They fully support the modern Excel workbook format (.xlsx), open several other formats (such as .xls, .ods, and .csv) as read-only, and do not open certain legacy or non-spreadsheet formats (for example .txt, HTML, SLK, XML, and .xltm) at all. The exact support varies by platform, so if your file will not open on mobile, open it in desktop Excel and re-save it as .xlsx, then open it on mobile.
Frequently Asked Questions
Why does double-clicking my file do nothing even though Excel opens?
The most likely cause is the "Ignore other applications that use Dynamic Data Exchange (DDE)" setting being turned on. Clear that check box in File > Options > Advanced > General. A broken file association or a conflict between multiple installed Office versions can cause the same symptom.
My workbook opens to a completely blank screen. Is the file corrupted?
Often not. A sheet or window may have been saved hidden (fix via View > Unhide), or the window may just need a minimize and maximize to refresh. Try those first, then disable add-ins one at a time and confirm Excel is not running in Compatibility mode before assuming corruption.
Should I open a file that warns its format does not match its extension?
Only if you trust where it came from. Microsoft advises not opening such a file from a source you cannot verify, because someone could have renamed a malicious file to trick you into opening it in Excel. If you do trust it, select Yes, then re-save it in the correct format.
What is the difference between Repair and Extract Data in Open and Repair?
Repair tries to recover as much of the workbook as possible and is the first choice. Extract Data is the fallback that pulls out only values and formulas when Repair cannot recover the file.
Should I use Quick Repair or Online Repair for Office?
Start with Quick Repair. It works offline and simply detects and replaces corrupted files, so it is faster. Online Repair is more thorough but reinstalls Office and requires an internet connection, so use it only if Quick Repair does not resolve the problem.
Why won't my old spreadsheet open at all, with no warning or repair option?
Current Excel can no longer open certain legacy formats, including Lotus 1-2-3 (.wk1 through .wk4), Microsoft Works (.wks), dBase II (.dbf), and Quattro Pro (.wq1, .wb1, .wb3). These have no in-app workaround, so you would need a different tool to convert them first.
