Fix an Excel Workbook That Hangs When a DDE Macro Runs
Question details
Identify why a DDE-enabled workbook hangs when its macro runs on one computer but works on another.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- An Excel workbook uses a DDE macro to connect to a third-party API.
- Observed behavior
- Excel hangs on one computer without displaying an error and must be closed through Task Manager.
Have access to both computers and identify the third-party DDE bridge or API application used by the workbook. Record the Excel versions and any messages shown when the workbook hangs.
Test the workbook in Excel Safe Mode
Use Safe Mode to check whether an Excel add-in or startup component contributes to the hang.
When Excel hangs, right-click its taskbar button and select Close window. Note whether Excel closes normally or displays a message before using Task Manager.
Press Windows+R, enter excel /safe, and select OK.
Open the workbook in Excel and run the same macro. Compare the result with a normal Excel session.
If the macro works in Safe Mode, restart Excel normally and go to File > Options > Add-ins. Use the Manage list and Go button to review Excel and COM add-ins, then disable them one at a time and retest.

Compare the DDE bridge and Excel settings
Use the working computer as a reference to find differences in the external connection or Excel configuration.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for common Excel formats, making it easy to move everyday spreadsheet work. It does not fix an Excel DDE hang; verify macro and DDE compatibility before relying on the workbook in WPS.

Frequently Asked Questions
What does it mean if the macro works in Excel Safe Mode?
An add-in or startup component may be involved. Restart Excel normally and review add-ins under File > Options > Add-ins, disabling them one at a time to identify a conflict.
Where can I find Excel's DDE setting?
Go to File > Options > Advanced > General and look for Ignore other applications that use Dynamic Data Exchange (DDE). Compare it with the working computer and consult the bridge vendor before changing it.
Why does the same workbook work on another computer?
The computers may differ in the DDE bridge process, firewall or antivirus rules, Excel add-ins, updates, or DDE settings. Compare those items with the working computer to narrow down the cause.
Can WPS Office fix the Excel DDE macro hang?
No. WPS Office is an alternative for spreadsheet work, not a repair for Excel or the third-party DDE bridge. Check compatibility with the workbook's macros and DDE connection before switching.




