In MS Excel, an error pop message reads the following: There was a problem sending a command to the program.
This problem may occur if the Ignore other applications that use Dynamic Data Exchange (DDE) check box in Excel options is selected.
When you double-click an Excel workbook in Windows Explorer, a dynamic data exchange (DDE) message is sent to Excel. This message instructs Excel to open the workbook that you double-clicked.
If you select the “Ignore” option, Excel ignores DDE messages that are sent to it by other programs. Therefore, the DDE message that is sent to Excel by Windows Explorer is ignored, and Excel does not open the workbook that you double-clicked.
To correct this setting, follow these steps:
- On the Tools menu, click Options.
- Click the Advanced \ General section.
- Clear the Ignore other applications that use Dynamic Data Exchange (DDE) check box, and then click OK.