Lỗi Excel There Was A Problem Sending The Command To The Program

Note

Office 365 ProPlus is being renamed to lớn longky.mobi 365 Apps for enterprise. For more information about this change, read this blog post.

Bạn đang xem: Lỗi excel there was a problem sending the command to the program


Symptoms

You receive the following error message in longky.mobi Excel. This error indicates that some process that is running inside Excel will not let Excel cthua.An error occurred when sending commands khổng lồ the program

Resolution

To resolve sầu this problem, try the following methods, as appropriate, in the given order.

Method 1: Ignore DDE

To correct this setting, follow these steps:

Select File > Options.Select Advanced, scroll down to the General section, và then clear the Ignore other applications that use Dynamic Data Exchange (DDE) kiểm tra box in the General area.SelectOK.

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 lớn Excel. This message instructs Excel to lớn open the workbook that you double-clicked.

If you select the "Ignore" option, Excel ignores DDE messages that are sent lớn it by other programs. Therefore, the DDE message that is sent lớn Excel by Windows Explorer is ignored, và Excel does not open the workbook that you double-clicked.


Note

For more information about how khổng lồ turn off DDE, see the following longky.mobi Knowledge Base article:


211494 "There was a problem sending the comm& to the program" error in Excel

If these steps bởi not resolve the problem, go to Method 2.

Method 2: Repair User Experience Virtualization (UE-V)

If you are running Update User Experience Virtualization (UE-V), install Hotfix Package 1 for longky.mobi User Experience Virtualization 2.0 (KB2927019).

If you are not sure whether you are running UE-V, examine the program các mục in the Programs & Features vật phẩm in Control Panel. An entry for "Company Settings Center" indicates that you are running UE-V.

If these steps vì chưng not resolve sầu the problem, go to lớn Method 3.

Method 3: Remix tệp tin associations

To kiểm tra whether the file associations in the system are performing correctly, rephối the Excel file associations to their mặc định settings. To bởi this, follow the steps for your operating system.Windows 10

Right-click the Excel workbook, point to xuất hiện with, & then clichồng More apps.Select the version of Excel you want lớn use to open this file type, such as Excel 2016.Cliông chồng to lớn select Always use this ứng dụng lớn open .xlsx files.Cliông xã OK.

Windows 8

On the Start screen, type Control Panel.Select Control Panel.Select Default ProgramsSet your default programs.Select ExcelChoose default for this program.On the Set Program Associations screen, select Select AllSave.

Windows 7

Select StartControl Panel.Select Default Programs.Select Associate a file type or protocol with a specific program.Select longky.mobi Excel Worksheet, và then select change program.Under Recommended Programs, select longky.mobi Excel.If Excel does not appear in this list, select Browse, locate the Excel installation folder, select Excel.exeExcel.

If these steps do not resolve the problem, go to Method 4.

Method 4: Repair Office

Try to lớn repair your Office programs. To bởi this, follow the steps for your installation type & operating system.

For an Office 365 Click-to-Run installation

Windows 10

In the tìm kiếm box, type Control Panel, & then clichồng Control Panel in the tìm kiếm results.Under Programs, cliông xã Uninstall a program.Clichồng longky.mobi Office 365 > Change.Clichồng Online Repair > Repair.
On the Start screen, type Control Panel.Select Control Panel.Under Programs, select Uninstall a program.Select **longky.mobi Office 365 **> Change.Select Online RepairRepair.

Windows 7

Select Start >Control Panel.Double-cliông xã Programs and Features.Select **longky.mobi Office 365 **> Change.Select Online RepairRepair.

Xem thêm: Tải Ảnh Thiên Nhiên Đẹp - Ghim Của Flowers In Heart Trên Beautiful Nature


*

For an Office 2016, 2013, Office 2010, or Office 2007 installation

To repair Office 2013, Office 2010, or Office 2007, follow the steps in the following Office website topic: Repair Office programs

If these steps bởi not resolve the problem, go to lớn Method 5.

Method 5: Turn off add-ins

Excel & COM add-in programs can also cause this problem. These two kinds of add-ins are located in different folders. For testing, disable and isolate the conflict by turning off each add-in one at a time. To vày this, follow these steps:

On the File menu, select OptionsAdd-Ins.In the Manage menu at the bottom of the screen, select COM Add-Ins > Go.Clear one of the add-ins in the danh mục, và then select OK.Restart Excel by double-clicking the ibé or tệp tin name for the workbook that you are trying khổng lồ open.If the problem persists, repeat steps 1-4, except select a different add-in in step 3.If the problem persists after you clear all the COM Add-ins, repeat steps 1-4, except select Excel Add-Ins in step 2, and then try each of the Excel add-ins one at a time in step 3.

If Excel loads the tệp tin, the add-in you last turned off is causing the problem. If this is the case, we recommend that you visit the manufacturer"s website for the add-in to lớn learn whether an updated version of the add-in is available. If a newer version of the add-in is not available, or if you don"t have sầu to use the add-in, you can leave sầu it turned off.

If Excel does not open the tệp tin after you turn off all the add-ins, the problem has a different cause.

If these steps bởi vì not resolve sầu the problem, go to Method 6.

Method 6: Disable hardware acceleration

To work around this problem, disable hardware acceleration until a fix is released by your video thẻ manufacturer. Make sure to lớn check regularly for updates to lớn your đoạn Clip card driver.

To disable hardware acceleration, follow these steps:

Start any Office 2013 program.

On the File tab, select Options.

In the Options dialog box, select Advanced.

In the các mục of available options, select the Disable hardware graphics acceleration kiểm tra box.

The following screen shot shows this option in Excel.

*

Select OK.


Note

For more information about hardware acceleration, see Performance và display issues in Office 2013 client applications (KB2768648).


If these steps vì not resolve the problem, go to Method 7.

Method 7: Verify or install the lakiểm tra updates

You may have sầu lớn set Windows Update to automatically tải về và install recommended updates. Installing any important, recommended, and optional updates can frequently correct problems by replacing out-of-date files và fixing vulnerabilities.

For more information about Office updates, cliông xã the following article number khổng lồ go to lớn the article in the longky.mobi Knowledge Base: Office Updates

longky.mobi Support

More Information

There are many possible reasons that might lead lớn this error.

The Excel workbook tries to lớn access data from another application that is still active.Too many Excel add-ins have sầu been added khổng lồ the program, or one of the add-ins is corrupted.You might have sầu taken one of the following actions:Use a third-các buổi party add-in or applicationTry to open an embedded objectSave or open a fileTry to use the Skết thúc as Attachment optionhotline another application from the Excel workbook

For more information about this problem & for additional troubleshooting steps, see the following longky.mobi Knowledge Base articles:

2616247 Why does "An error occurred when sending commands to the program" appear when opening Excel 2010 files? (Easy Fix Article)

2994633 Excel: How to lớn Troubleshoot Excel opening blank when you double-click a tệp tin ibé or tệp tin name