LỖI EXCEL THERE WAS A PROBLEM SENDING THE COMMAND TO THE PROGRAM

Typically, Windows users experience “there was a problem sending the comm& to the program excel” error. So, you are not alone. Windows usually skết thúc commands to the MS Office using the Dynamic Data Exchange. However, when Windows OS fails to connect with Microsoft Excel, then this annoying error is triggered.

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

*

When you cliông chồng, OK, the problem is solved. However, the error pops up again when you restart your PC. Take note that if the error persists every time you open a file, then you must resolve the issue.

This guide demonstrates how users of excel can solvethere was a problem sending the command khổng lồ the program exceleffortlessly.

There was a Problem Sending the Command to lớn the Program Error

When this error occurs every time you try khổng lồ access your Excel file try the following solutions:

Solution 1: Disable or Unkiểm tra Dynamic Data Exchange (DDE)

According to lớn the users of Windows, theDynamic Data Exchangemay causethere was a problem Sending the commvà khổng lồ the program excel 2007,2010 & 2016.

The good news is that you can permanently disable this comm&.

Follow these quiông chồng steps:

First, open Excel Microsoft Office Program causing this errorNext, cliông xã the File menu and select OptionsNow, from the Excel Options dialogue window, cliông chồng AdvancedScroll down to lớn the “General” section.After that, unkiểm tra the “Ignore other applications that use Dynamic Data Exchange (DDE)”Click OK lớn confirm the changes & then restart your Office program .

*

Tip:If the option is already unchecked, enable it and restart your Office application. Then disable it.

Double-clicking an Excel spreadsheet using Windows OS sends a Dynamic Data Exchange command lớn Excel. Usually, the command is an instruction lớn open the needed Excel file that you have sầu double-clicked.

If you select “Ignore other applications that use DDE” all the commands sent to DDE by Windows are ignored. As a result, Excel fails khổng lồ open the document you require, và the error pops up.

Go to solution two if the steps stipulated above sầu fail to remove the program error.

Solution 2: Change other Excel Program settings

If disabling the DDE option fails lớn work, you can still change a few settings and see if they solve sầu the error. Now, you need not change all the options at once. Instead, replace them one by one và be sure khổng lồ confirm if the settings work.

Click the File Menu.On the Excel Options, select theTrust Center.

*

Now, clichồng the Trust Center SettingsSelect External Content from the Trust Center dialogue boxEnsure that you enable both the security settings for Data Connections and Workbook liên kết.

*

Clichồng OK to confirm the changes.

If this option does not work, proceed khổng lồ save the following changes:

First, select Trust Center from the Excel Options.Next, click Trust Center Settings.From the Trust Center dialogue box Window, select Macros Settings.Now, on the Macro Settings, selectEnableall macros (not recommended; potentially dangerous code can run) Option.Also, kiểm tra the Trust access lớn the VBA project object model checkbox.

*

Click OK lớn confirm the changes và resolve the error.

Xem thêm: Cách Chèn Bảng Tính Excel Vào Word 2007, 2010, 2013, Cách Chèn Bảng Tính Excel Vào Word 2007

If changing trust center settings fails to work, then disable hardware acceleration in the advanced settings.

First, clickOptionsfrom the Excel File Menu.Now, an Excel Options dialogue box Window opens.Cliông xã onAdvanced.Under the display section, check“Disable hardware graphics acceleration”box.

*

ClickOKto save changes và fix the error.

The good news is that this problem will resolve sầu your error. However, the bad news is that your performance will drop significantly.

However, if the problem fails to lớn resolve sầu, unkiểm tra this option & try the next solution.

Solution 3: Disable "Run as an Administrator" Option

At other times the error occurs if the "Run as administrator" option is enabled in the Excel program. Whenthere was a problem sending the command to the program excel 2010,2007 and 2016, follow these simple steps:

For this scenario, type Microsoft Excel.

Right-cliông xã on Microsoft Excel and select the Properties option.If you can"t access Properties, selectOpen file locationfrom the drop-down menu.

*

Another window opens. Select & right-clichồng on Excel.From the drop-down thực đơn, select the Properties option.Now, clichồng on Compatibility from the Excel Properties dialogue boxDisable all options including “Run this program as an administrator”Clichồng OK khổng lồ confirm changes & fix the error.

*

Solution 4: Repair Microsoft Office

Sometimes, if your MS Office is damaged, then there was a problem sending the comm& lớn the program error occurs. When this error occurs, it is advisable lớn repair the Microsoft Office.

It is easy to repair your Microsoft Office ifthere was a problem sending the command khổng lồ the program excel 2016. Once you’re done, confirm if the solution helps. These steps are also applicable khổng lồ Excel 2007 and 2010.

First, in the tìm kiếm box, type Programs, và Features and hit EnterNext, select the Microsoft Office, causing this annoying error. Right-cliông xã & selectChangeAfter that, cliông xã on Repair and then cliông chồng theContinueButton

However, if this solution fails, consider uninstalling your Microsoft Office. One of the best không lấy phí software tools isIObit Uninstaller. Removing Office ensures that all the errors are permanently fixed. After that, be sure lớn reinstall your Office.

Solution 5: Disable your Anti-Virus Software

Ifthere was a problem sending the command to the program excel 2007, your anti-vi khuẩn might be the cause. The answer is, therefore, to lớn disable the software temporarily.

If you don’t have sầu a software like Norton, disable your Windows defender.

On the Start thực đơn, type Windows Defender và openA Windows Defender window opensClichồng on Settings and disable real-time protection

If this fails to fix the problem, then consider removing your anti-vi khuẩn permanently.

Nonetheless, consider changing your anti-virut if this solution solves the error.

Solution 6: Switch Off Excel Add-ins

Although Add-ins create exciting features in Excel, at times, they cause such comm& errors. We’d advise that you turn off all excel add-ins if you’re experiencing such a problem. Follow these steps:

Launch your Microsoft Excel Program displaying the errorCliông chồng File menu & select OptionsOn the Excel Options, Dialogue box window clichồng Add-Ins

*

At the bottom of the window, Select COM Add-ins on the Manage sectionClichồng on GoFrom the available danh mục given, clear one of the COM Add-ins & click OK

*

Now double click on the Excel workbook or sheet to lớn restart the programIf the problem continues, cliông xã another available add-in in the COM Add-ins list

However, if the error persists after trying all the available COM add-ins, use Excel Add-ins.

Click on File from your Excel WorksheetSelect Options and Clichồng Add-InsNow, an Excel Options dialogue box window opens.On the manage sections, select Excel Add-InsCliông chồng on GoAn Adds-in Window pops up. Disable all the add-ins to lớn confirm if these add-ins cause the error

*

If these add-ins are the cause, then enable the available Add-ins one by one khổng lồ identify the problematic Add-in.Cliông xã OK once you’re through.Finally, clichồng OK again to lớn confirm the changes.

That said, you have sầu successfully learned khổng lồ solvethere was a problem sending the commvà khổng lồ the program excel. The problem is comtháng lớn all users of Windows, so you need not panic. When the error occurs, choose any solution in this guide and solve it in the comfort of your trang chủ.Learn more about Microsoft Office errors Here.

If you’re looking for a software company you can trust for its integrity and honest business practices, look no further than geektechreviews.com. We are a Microsoft Certified Partner and a BBB Accredited Business that cares about bringing our customers a reliable, satisfying experience on the software products they need. We will be with you before, during, and after all the sales.

That’s our 360 Degree geektechreviews.com Guarantee. So, what are you waiting for? hotline us Today on +1 877 315 1713 or gmail sales