File Cannot Open

Fix Excel Files That Do Not Open by Double-Clicking

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 870 views

Question details

The user wants Excel workbook files to open directly in Excel when double-clicked, instead of Excel opening only manually from the Start menu.

Fix Excel Files That Do Not Open by Double-Clicking
Product
Microsoft Excel
Device & OS
Windows
Scenario
The user double-clicks an Excel workbook in Windows, expecting the file to open in Excel.
Observed behavior
Excel opens normally from the Start menu, but double-clicking a workbook does not open it in Excel because the Ignore Dynamic Data Exchange (DDE) setting may block the file handoff.
Before you start

Open the problematic workbook manually in Excel by choosing File > Open. If it opens correctly, the issue is likely file handoff rather than workbook corruption, and you can safely change the DDE setting.

Solution 1Recommended

Clear the Ignore DDE Setting in Excel Advanced Options

Use this solution when Excel starts normally but double-clicked workbooks do not open, because the Windows file handoff is being blocked.

Excel's 'Ignore other applications that use Dynamic Data Exchange (DDE)' setting can prevent Windows from passing the double-clicked file name to Excel. Clearing this option restores the normal file handoff without affecting the workbook content.

1
Open Excel Options

Open Excel from the Start menu and select File > Options.

2
Go to Advanced

In the Excel Options dialog, click Advanced in the left pane.

3
Locate the General section

Scroll to the General section and find 'Ignore other applications that use Dynamic Data Exchange (DDE)'.

4
Clear the DDE checkbox

Clear the checkbox if it is selected, then click OK to save the change.

5
Test the workbook

Close Excel completely, then double-click the workbook in File Explorer to confirm it opens.

Clear the Ignore DDE Setting in Excel Advanced Options
File handoff restored: Excel should now accept the double-click file handoff and open the workbook directly.
Free Microsoft Office alternative

Open and Edit Excel Workbooks Free in WPS Office

If Excel's DDE file-association issues keep interrupting your work, WPS Office is a free, lightweight Microsoft Office alternative that opens and edits Excel workbooks with full .xlsx compatibility, a familiar ribbon interface, and easy migration from Microsoft Excel.

  1. 1. Download WPS Office Free: Go to the official WPS Office website, download the free installer, and follow the Windows setup prompts.
  2. 2. Set WPS Spreadsheets as the default app: Right-click an Excel file in File Explorer, select Open with > Choose another app, choose WPS Spreadsheets, and check 'Always use this app to open .xlsx files'.
  3. 3. Double-click to open workbooks: Double-click the Excel file again to open and edit it directly in WPS Spreadsheets.
Opens Excel workbooks directly by double-click after setting WPS Spreadsheets as the default appFull compatibility with .xlsx, .xls, and other Excel file formatsFree spreadsheet tools with a familiar Office-style ribbon interfaceLightweight Windows installation that starts quickly and uses fewer resources
microsoft office alternative - wps office

Frequently Asked Questions

Why does Excel open from the Start menu but not when I double-click a workbook?

This usually means Windows is not passing the file path to Excel. The Excel option 'Ignore other applications that use Dynamic Data Exchange (DDE)' can block that handoff, so the file double-click does nothing while Excel itself still starts normally.

Where do I find the Ignore DDE option in Excel?

Open Excel and go to File > Options > Advanced. Scroll to the General section and locate 'Ignore other applications that use Dynamic Data Exchange (DDE)'. Clear the checkbox and click OK.

Can WPS Office open .xlsx files if Excel still won't open them by double-click?

Yes. WPS Spreadsheets can open, edit, and save .xlsx and .xls files. Right-click the Excel file, choose Open with > Choose another app, select WPS Spreadsheets, and set it as the default app.

Will clearing the DDE setting affect my workbook data or Excel macros?

No. Clearing the DDE setting only changes how Windows hands file paths to Excel. It does not modify workbook data, formatting, or macros.