How to fix Microsoft Excel 'There was a problem sending the command to the program' error when opening files

Summary

This guide helps you troubleshoot and resolve: How to fix Microsoft Excel 'There was a problem sending the command to the program' error when opening files. Follow the steps below to fix the issue.

Common Causes

The "There was a problem sending the command to the program" error typically appears in Microsoft Excel when opening files, particularly .xlsx, .xls, or .csv documents. This issue is usually caused by conflicts with Excel add-ins, Dynamic Data Exchange (DDE) settings, or problems with your Office installation. The steps below will walk you through resolving the error in order from quickest fix to more advanced solutions.

Quick Fix Steps

Before diving into detailed troubleshooting, try these common solutions:

1. Restart Excel completely and try opening the file again.
2. Open Excel in Safe Mode by pressing Windows + R, typing excel /safe, and pressing Enter. If the file opens in Safe Mode, an add-in is likely the cause.
3. Ensure your version of Office is up to date by going to File > Account > Update Options > Update Now.

Detailed Instructions

Enable the Ignore DDE Option

The Dynamic Data Exchange (DDE) feature is a common trigger for this error. Enabling the option to ignore DDE resolves the issue for most users.

1. Open Excel and click File > Options.
2. Select Advanced from the left-hand menu.
3. Scroll down to the General section.
4. Tick the box next to Ignore other applications that use Dynamic Data Exchange (DDE).
5. Click OK and restart Excel.

Disable Problematic Add-ins

Faulty or outdated add-ins frequently cause this error, especially COM add-ins and third-party integrations.

1. Open Excel and go to File > Options > Add-ins.
2. At the bottom of the window, change the Manage dropdown to COM Add-ins and click Go.
3. Untick all add-ins in the list and click OK.
4. Restart Excel and test opening your file.
5. If the file opens successfully, return to the COM Add-ins window and re-enable add-ins one at a time to identify the culprit.

Repeat the process for Excel Add-ins and XML Expansion Packs if the issue persists.

Reset Excel File Associations

Incorrect file associations in Windows can prevent Excel from receiving the correct command when opening files.

1. Close Excel completely.
2. Right-click the Start button and select Settings > Apps > Default apps.
3. Scroll down and click Choose defaults by file type.
4. Locate each Excel extension (.xlsx, .xls, .xlsm, .csv) and ensure Microsoft Excel is selected as the default app.
5. Try opening your file again.

Check the File Path

Excessively long file paths or paths containing certain special characters can also trigger this error.

1. Move the file to a simple location such as C:\Temp\ or your Desktop.
2. Try opening the file from the new location.
3. If successful, save the file with a shorter name and avoid folders with deep nesting.

Repair Your Office Installation

If the above steps have not resolved the error, your Office installation may have corrupted files.

1. Close all Office applications.
2. Open Control Panel > Programs > Programs and Features.
3. Locate Microsoft 365 or Microsoft Office in the list and click it once.
4. Click Change at the top of the list.
5. Select Online Repair for the most thorough fix, then click Repair.
6. Restart your computer once the repair is complete.

Clear the Excel Temp Folder

Corrupted temporary files can interfere with Excel's ability to open documents.

1. Close Excel completely.
2. Press Windows + R, type %temp%\Microsoft\Excel, and press Enter.
3. Select all files in the folder (Ctrl + A) and delete them.
4. Restart Excel and try opening your file.

Troubleshooting

The Error Appears Only with Specific Files

If the error occurs with one particular file, the document itself may be corrupted. Try the following:

• Open Excel and use File > Open > Browse rather than double-clicking the file.
• Copy the contents into a new workbook.
• Ask the sender to resend the file or save it again from the original source.
• Try opening the file in Google Sheets or LibreOffice Calc to recover the data.

The Error Appears After a Windows Update

Recent Windows updates occasionally break Office compatibility. Check for:

• Pending Office updates via File > Account > Update Options.
• Known issues on the Microsoft Office support page.
• Optional Windows updates that may need to be rolled back via Settings > Windows Update > Update history.

Using Excel on a Mac

Mac users encountering this error should try:

1. Clearing the Excel cache by quitting Excel, then deleting files in ~/Library/Containers/com.microsoft.Excel/Data/Library/Caches/.
2. Removing Excel from System Settings > Privacy & Security > Full Disk Access, then re-adding it.
3. Running Disk Utility > First Aid to check for file system errors.

Still Having Issues?