Windows is full of surprises when you encounter error messages such as this one out of the blue. “There was a problem sending a command to the program” usually indicates that a window has failed to connect with the MS Office Applications (such as Excel, Word or Access database etc.) in the process of sending DDE (Dynamic Data Exchange) commands to the MS Office applications. As a result, you are not able to run MS Office Applications.
Sometimes, this error can be corrected by itself, as the error message pops up only once and the applications run in the second or third attempt. BUT this does not mean it should be left untreated, hence it needs to be fixed manually, as it may come back.
If you have the Microsoft’s Compatibility Viewer then uninstall it and try to open the Excel file. If it doesn’t work then repair the Microsoft Office (from the programs and features window) and then check.
Method 1: Disabling Run program as administrator
Select Properties by Right clicking on the shortcut of the applications showing the error message and select the Compatibility tab.
Uncheck the Run program as administrator box if its checked or enabled.
Method 2: Checking DDE Option (Excel)
Open MS Office EXCEL and open Excel Options box from the OFFICE Menu by clicking on the Office icon on the top left corner of the application and click on Advanced
Locate the option called Ignore other applications that use Dynamic Data Exchange (DDE) under General Options and uncheck/disable it. Restart the office application after applying changes.
If the Ignore other applications that use Dynamic Data Exchange (DDE) option is unchecked or disabled, enable the option from the check box and restart the office application and then again uncheck the option and restart the office application.
Method 3: Change Excel Settings
There are a few settings that you can change to see if it helps. There are a lot of options that you can change but you don’t have to change all of these settings. You can change the settings one-by-one and keep checking if the problem is resolved.
- Open Microsoft Excel
- Click File
- Select Options
- Select Advanced from the left pane
- Uncheck the option Ignore other applications that use Dynamic Data Exchange (DDE). This option should be in the General
- Click Ok and check if the problem is still there or not. If the problem persists then continue
- Select Trust Center
- Click Trust Center Settings
- Select External Content
- Enable both Security settings for Data Connections and Security settings for Workbook Links
- Click Ok and check if the problem is solved. If not then continue.
- Select Trust Center
- Click Trust Center Settings
- Select Macro Settings
- Select the option Enable all macros (not recommended; potentially dangerous code can run)
- Check the option Trust access to the VBA project object model
- Click Ok and check if the problem is solved. If not then continue.
- Select Trust Center
- Click Trust Center Settings
- Select ActiveX Settings
- Select the option Enable all controls without restrictions and without prompting. (not recommended; potentially dangerous code can run)
- Click Ok and check if the problem is solved. If not then continue.
- Select Trust Center
- Click Trust Center Settings
- Select Privacy Options
- Uncheck the option Check Microsoft Office Documents that are from or link to suspicious websites.
- Click Ok and check if the problem is solved.
Method 4: Registry Fix
Even if the method 1 didn’t work for you there is still hope for you. There is a registry fix that has worked for a lot of users. Follow the steps given below to fix the issue via the registry.
Note: Messing up registry keys can cause serious issues. So, it is advised to make a backup of your registry keys in case something goes wrong. Click here for a step-by-step guide on how to backup and restore your registry.
- Open the Run dialog box by pressing Windows + R
- Type regedit in the box and press Enter or click ok.
- Now, navigate to this address HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open. If you don’t know how to navigate to this path then follow the steps given below
- Locate and double click HKEY_CLASSES_ROOT from the left pane
- Locate and double click Excel.Sheet.8 from the left pane
- Locate and double click shell from the left pane
- Locate and double click Open from the left pane
- Right click ddeexec folder/key (it should be under Open) and select Delete. You can also just rename the ddeexec folder/key if you aren’t comfortable. Simply right click and select Rename, and just give it any name you want.
- Now, select the command folder/key by left clicking it once (it should be under Open)
- Double click the Default string from the right pane
- Replace the /e or /dde part of the value with “%1”. Note: Include the quotes as well.
- The Default string’s value should look like this “C:\Program Files (x86)\Microsoft Office\Office15\EXCEL.EXE” “%1”
- Click Ok
- Double click the command string from the right pane
- Replace the /e or /dde part of the value with “%1”. Note: Include the quotes as well.
- The Command string’s value should look like this yh1BV5!!!!4!!!!MKKSkEXCELFiles>Of1RD?I9b9j[2hL]KhO& “%1”
- Click Ok
- Now, scroll up just a little bit in the pane and double click Excel.Sheet.12
- Repeat steps from 4-13 for Excel.Sheet.12
Once done, check if the issue is resolved or not.
Method 5: Check and Disable Excel Add-ins
Sometimes the Excel add-ins might cause this issue. If you recently installed an add-in or around the time when this problem started then that is an indicator as well. Even if you don’t remember, disabling or uninstalling the add-ins from your Excel is worth a try.
- Open Excel
- Click File
- Select Options
- Select the Add-ins from the left pane
- Select the Add-in from the list
- In the Manage box, click Excel Add-ins, and then click Go…
- In the Add-Ins available box, uncheck the option next to the add-in that you want to disable. We will recommend to disable all the add-ins just to check if the problem is caused by the add-ins or not.
- Once done, click ok
- Click Ok again
This should do the job for you. If the problem is resolved then it’s clear that an add-in was causing the issue. You can now follow the above given steps and enable the add-ins one-by-one to determine which add-in was the root of the problem.
Method 6: Disable Dell Data Protection Security Authentication Service
Note: This method is for Dell users. If you aren’t using a Dell computer then skip this method.
If you have a Dell machine then the issue might be related to the Dell Data Protection Security Authentication Service. This is a service installed via Dell’s Digital Delivery service. Its main purpose is to provide security solution and authentication support. The reason behind the problem relating to this service is not known but there are a ton of Dell users who solved their issue by disabling or uninstalling this Dell service.
The steps to disable the Dell Data Protection Security Authentication Service are given below
- Hold Windows key and press R
- Type services.msc and press Enter
- Locate and double click the Dell Data Protection Security Authentication Service
- Select Disabled from the drop down menu
- Make sure the service status is stopped. If it isn’t then click the Stop button in the Service Status section
- Click Apply then select Ok
Check if the issue is resolved. If the problem is gone then you know the culprit behind the issue. You can keep this service disabled without facing any major issues. You can also uninstall this service from the Programs and Features window if you really don’t want the service. On the other hand, if the problem still persists then you can simply turn on the service back again. Just follow the steps from 1-6 above but select the Automatic option in step 4.
Method 7: Disable Hardware Acceleration
The problem might also be caused by your video card. So, disabling this option solves the issue. This isn’t a solution but more of a workaround. So, keep checking for the latest updates from your video card manufacturer because there’s a high likelihood that your card manufacturer will release an update for this issue.
- Open Excel
- Click File
- Select Options
- Select Advanced from the left pane
- Check the option Disable Hardware Acceleration. This option should be under the Display section
- Click Ok
Once done, this should solve the issue. Keep this option enabled until you see a new update from your video card manufacturer. You should disable this option after updating the video card. If this method doesn’t solve the issue then there’s no need to keep this option enabled. Simply follow the steps given above and Uncheck the Disable Hardware Acceleration option in the step 5.
Method 8: Reset Default Programs and File Associations
Sometimes the issue can be caused the Excel isn’t the default program to run the .xlsx files. Simply making Excel the default program and resetting the file associations solves this issue for us.
Follow the steps given below to reset the file associations
- Hold Windows key and press R
- Type control panel and press Enter
- Type Default programs in the search bar located at the top right corner
- Select the Default Programs option
- Select Set your default programs
- Wait a while for the list to populate
- Locate and select Excel
- Click Choose defaults for this program
- Check the option Select All
- Click Save
Method 9: Uninstalling Additional Office Viewer:
This error message may also occur, if you have installed Office Viewer next in conjunction to Microsoft Office. If this is the case, uninstall it and re-test.