PRO
BlogBooster
PBB

[Fixed] “There was a Problem Sending the Command to the Program” - Microsoft Excel Troubleshooting

I have been just fed up with these simple errors causing my workout very slow while working. An error occurred when sending commands to the program in Microsoft Excel. These following steps show how to fix the issue when you are going to open Excel, and it pops up with the message - "There was a Problem Sending the Command to the Program".

Fixing "An error occurred when sending commands to the program" error in Excel 2003/2007/2010/2016/2019
The error 'There was a problem sending the command to the program' is one of the most annoying common errors faced by many Windows users. Normally, this error is derived by and with the Office installer package and generated while the users trying to open Excel, PowerPoint, Word, or Access files created in variable Office versions and has been reported by Windows 7, 8 and Windows 10 users as well

When I was trying to open by double-clicking on the '.xlsx' or '.xls' file in Microsoft Excel, it's showing that error message "There was a Problem Sending the Command to the Program" quickly before opening the actual file. Then I initially had a look at the file, and it seemed good enough, and I found that I have unexpected error only with Microsoft Excel itself.

While opening the office files, the Windows compiler sends DDE (Dynamic Data Exchange) commands to Microsoft Office tools, but the system unable to read and so to call that particular app and this failure triggers the error message 'There was a problem sending the command to the program'.

Note that this solution also works well with any Microsoft tool including Microsoft Word, Excel 2003/2007/2010/2016/2019. Simple tutorial to fix Microsoft Excel Errors.
Fix - There was a Problem Sending the Command to the Program
Fix - There was a Problem Sending the Command to the Program: How do you fix there was problem sending the command to the program? How do you fix there was a problem sending the command to the program in Excel 2007? Why are commands not working in Excel? How do I ignore other applications using Dynamic Data Exchange? If you're having problems with There was a problem sending the command to the program error message, it indicates that a window has failed to connect with the MS Office Applications.
Last time you saw troubleshooting Microsoft word - [FIX] 'Word Experienced An Error Trying To Open The File'; it's been just solved and after solving that error I suddenly encountered this error while using Microsoft Excel. But after troubleshooting Microsoft Excel I got the solution and then finally able to open and edit my excel file.

Why there is an error "There Was a Problem Sending the Command to the Program"?

The "There was a problem sending the command to the program" error in Microsoft Excel typically occurs due to issues with DDE (Dynamic Data Exchange) settings or conflicts with Excel Add-ins. It may also arise if there's a problem with the file association or if the Excel application is not running properly. This error message often appears when trying to open Excel files from external sources.

To resolve this issue, you can try solutions such as adjusting DDE settings, disabling Add-ins, repairing Microsoft Office, or ensuring that Excel is set as the default program for opening Excel files.


Fixing "There was a Problem Sending the Command to the Program"

To be honest, I am not Microsoft Excel Experts, so I go to view and check the 'xls' files online, but it didn't work for me. Then I go through excel mobile app, and it was opening my file to edit, so it confirms that there is no problem with the xls file.

Then while troubleshooting Microsoft Excel, I found that the reason behind this error is Dynamic Data Exchange [DDE]. I found from the ms excel developer that, it's a communication protocol typically used to communicate the source of the file with the Microsoft tool.

This feature helps the operating system to handle minimum resources and keep the computer at high speed. In short, this error encounters when windows unable to connect by DDE with the application while opening the source of the file. Well, the solution is straightforward and easy to fix it.

Follow the steps given below to solve the error message "An error occurred when sending commands to the program":

Step 1. Make sure to set default program.

Check the default program for that particular file extension. If you have .xls then you need to have Microsoft Excel as a default program for that.
  • For this, right click on that file >> choose 'Open with' >> and choose appropriate program as shown below

  • for .doc, .docx choose Microsoft Word

  • For .xls, .xlsx choose Microsoft Excel

[If you don't have the appropriate program listed then you need to add from the installed location]

You must check; 28 Steps Make Chrome 8x Faster (100% Working) | How Chrome Flags Speedup Browsing

Step 2. Ignore other applications that use Dynamic Data Exchange [DDE].

To fix the "There was a problem sending the command to the program" error in Excel, disable the "Ignore other applications that use Dynamic Data Exchange (DDE)" option in File > Options > Advanced > General. Alternatively, run an online repair on Microsoft Office via the Control Panel.

  • Open Microsoft Excel >> Options >> Advanced >> In General tab you will see the option to 'Ignore other applications that use Dynamic Data Exchange (DDE)'.
  • [As shown in picture]

    Fix - There was a Problem Sending the Command to the Program
RECOMMENDED: Make Computer Run 10x Faster By Using Virtual Memory | RAM Optimization

Update: 5 May 2017

Just recently, I have removed the OS tuning tool called 'TuneUp utilities' and then that annoying error message has been gone. So what I would be recommending to others is to check all the installed software, programs or tools that you think are incompatible with the Microsoft Office; then uninstall the program quickly.


Excel Troubleshooting Guide

1. What to do when Excel says "There's a problem with this formula"?

This error usually appears when you type a formula and press Enter, but Excel cannot calculate it.

  • Check the Error Message: Excel often provides a specific pop-up or a green triangle in the corner of the cell. Click it to see the specific issue (e.g., "Inconsistent Formula," "Circular Reference").
  • Use "Evaluate Formula":
    1. Select the cell with the error.
    2. Go to the Formulas tab > Formula Auditing > Evaluate Formula.
    3. Click Evaluate repeatedly to see which part of the calculation fails.
  • Check Syntax:
    • Ensure all parentheses () are closed.
    • Check text strings are in quotes "Text".
    • Verify separators: Some regions use commas , while others use semicolons ; to separate arguments.
  • Check for Circular References: Go to Formulas > Error Checking > Circular References. If a cell refers to itself, Excel cannot solve it unless Iterative Calculation is enabled.
  • Unprotect the Sheet: If the cell is locked, you cannot edit the formula. Go to Review > Unprotect Sheet.


2. How to fix DDE Error in Excel?

A DDE (Dynamic Data Exchange) error often says "Excel cannot open the file... DDE server not responding" or prevents files from opening via double-click.

  • Fix 1: Uncheck "Ignore Other Applications" (Most Common Fix)
    1. Open Excel (blank workbook).
    2. Go to File > Options > Advanced.
    3. Scroll down to the General section.
    4. Ensure "Ignore other applications that use Dynamic Data Exchange (DDE)" is UNCHECKED.
    5. Click OK and restart Excel.
  • Fix 2: Change Default Printer
    • Sometimes a corrupt printer driver causes DDE hangs. Go to Windows Settings > Printers & Scanners and set "Microsoft Print to PDF" as your default temporarily. Try opening Excel again.
  • Fix 3: Disable Hardware Graphics Acceleration
    1. Go to File > Options > Advanced.
    2. Under Display, check "Disable hardware graphics acceleration". (Note: This option is removed in very recent Office 365 updates).
  • Fix 4: Repair Office
    1. Close all Office apps.
    2. Go to Windows Control Panel > Programs and Features.
    3. Right-click Microsoft Office > Change > Select Quick Repair.


3. How to resolve Script Error in Excel?

Script errors usually appear as a pop-up saying "An error has occurred in the script on this page." This is often related to how Excel interacts with Windows Internet settings or Add-ins.

  • Fix 1: Disable Script Debugging (Windows Setting)
    1. Close Excel.
    2. Press Windows Key + R, type inetcpl.cpl, and press Enter (opens Internet Properties).
    3. Go to the Advanced tab.
    4. Under Browsing, check "Disable script debugging (Internet Explorer)".
    5. Check "Disable script debugging (Other)".
    6. Uncheck "Display a notification about every script error".
    7. Click Apply/OK and restart Excel.
  • Fix 2: Clear Temporary Internet Files
    1. In the same Internet Properties window (from step above).
    2. Under General, click Delete... under Browsing History.
    3. Ensure Temporary Internet Files is checked and delete them.
  • Fix 3: Disable COM Add-ins
    1. Open Excel in Safe Mode (Hold Ctrl while clicking the Excel icon).
    2. If the error stops, an Add-in is the cause.
    3. Go to File > Options > Add-ins.
    4. At the bottom, manage COM Add-ins > Go. Uncheck them one by one to find the culprit.


4. How to solve Excel Opening Problem?

If Excel crashes on startup, freezes, or refuses to open files.

  • Fix 1: Open in Safe Mode
    1. Hold the Ctrl key on your keyboard and double-click the Excel icon.
    2. Click Yes when asked to start in Safe Mode.
    3. If it opens successfully, the issue is likely an Add-in or a Corrupt Startup File.
  • Fix 2: Delete Excel Startup Files
    1. Close Excel.
    2. Press Windows Key + R.
    3. Type %appdata%\Microsoft\Excel\XLSTART and press Enter.
    4. Delete any files inside this folder (these are files that try to load automatically and may be corrupt).
  • Fix 3: "Open and Repair" a Specific File
    1. Open Excel (blank).
    2. Go to File > Open > Browse.
    3. Select the corrupt file (click it once).
    4. Click the small arrow next to the Open button and select Open and Repair.
  • Fix 4: Update Office
    1. Go to File > Account.
    2. Click Update Options > Update Now.


Summary Checklist if Nothing Works:

  • Restart your computer.
  • Run a Full Office Repair (Control Panel > Programs > Microsoft Office > Change > Online Repair).
  • Check Antivirus: Temporarily disable third-party antivirus software to see if it is blocking Excel.
  • Reinstall: As a last resort, uninstall and reinstall Microsoft Office.


Hope that helps.

That's all, and your problem gets solved. You've mastered the resolution for the "There was a problem sending the command to the program" Excel error. Now you can check your file.

Don't worry; this issue is widespread among Windows users. When confronted with the error, confidently select a solution from this guide and troubleshoot it from the convenience of your home.

If you know any other quick solution, then you can share with me via comment section shown below.


If you enjoyed this article, please share it with your friends and help us spread the word.
What other people reading right now...!!?!!
Loading...
Next Post Previous Post
No Comment
    We would love to hear from you!
    comment url

    Testimonials

    Disclaimer

    We are a professional review site that operates like any other website on the internet. We value our readers' trust and are confident in the information we provide. The post may contain some affiliate/referral links, and if you make a purchase through them, we receive referral income as a commission. We are unbiased and do not accept fixed marketing articles or fake reviews. We thoroughly test each product and only give high marks to the very best. We are an independent organization and the opinions/views/thoughts expressed here are our own.

    Privacy Policy

    All of the ProBlogBooster ideas are free for any type of personal or commercial use. All I ask is to keep the footer links intact which provides due credit to its authors. From time to time, we may use visitors/readers, information for distinct & upcoming, unanticipated uses not earlier disclosed in our privacy notice. If collected data or information practices changed or improved at some time in the future, we would post all the policy changes to our website to notify you of these changes, and we will use for these new purposes only data collected from the time of the policy change forward. If you are concerned about how your information is used, you should check back our website policy pages periodically. For more about this just read out; Privacy Policy