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

Typically, Windows users experience “there was a problem sending the command lớn the program excel” error. So, you are not alone. Windows usually sover commands to lớn the MS Office using the Dynamic Data Exchange. However, when Windows OS fails lớn 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 xã, 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 tệp tin, then you must resolve the issue.

This guide demonstrates how users of excel can solvethere was a problem sending the comm& lớn the program exceleffortlessly.

There was a Problem Sending the Commvà to the Program Error

When this error occurs every time you try lớn access your Excel file try the following solutions:

Solution 1: Disable or Uncheck Dynamic Data Exchange (DDE)

According lớn the users of Windows, theDynamic Data Exchangemay causethere was a problem Sending the comm& to the program excel 2007,2010 và 2016.

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

Follow these quichồng steps:

First, open Excel Microsoft Office Program causing this errorNext, clichồng the File menu và select OptionsNow, from the Excel Options dialogue window, cliông chồng AdvancedScroll down 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 & 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 comm& is an instruction to lớn open the needed Excel file that you have double-clicked.

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

Go to lớn solution two if the steps stipulated above sầu fail khổng lồ remove sầu 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 & see if they solve sầu the error. Now, you need not change all the options at once. Instead, replace them one by one & be sure lớn confirm if the settings work.

Cliông chồng 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 và Workbook liên kết.

*

Click OK lớn confirm the changes.

If this option does not work, proceed to save the following changes:

First, select Trust Center from the Excel Options.Next, cliông xã 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 mã sản phẩm checkbox.

*

Click OK to lớn confirm the changes and resolve sầu the error.

Xem thêm: Những Hình Ảnh Cực Thú Vị Về Cơ Thể Con Người, Google Ống Kính

If changing trust center settings fails to lớn 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 sầu changes & 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, uncheck this option và 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 comm& to lớn the program excel 2010,2007 and năm 2016, follow these simple steps:

For this scenario, type Microsoft Excel.

Right-clichồng on Microsoft Excel & select the Properties option.If you can"t access Properties, selectxuất hiện file locationfrom the drop-down thực đơn.

*

Another window opens. Select và right-cliông xã on Excel.From the drop-down thực đơn, select the Properties option.Now, cliông chồng on Compatibility from the Excel Properties dialogue boxDisable all options including “Run this program as an administrator”Clichồng OK to confirm changes and fix the error.

*

Solution 4: Repair Microsoft Office

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

It is easy to lớn repair your Microsoft Office ifthere was a problem sending the comm& lớn 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, & Features và hit EnterNext, select the Microsoft Office, causing this annoying error. Right-click and selectChangeAfter that, cliông xã on Repair & 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 commvà to lớn the program excel 2007, your anti-vi khuẩn might be the cause. The answer is, therefore, lớn disable the software temporarily.

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

On the Start menu, type Windows Defender và openA Windows Defender window opensCliông xã on Settings và 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-virus 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 command 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 errorClick File thực đơn & select OptionsOn the Excel Options, Dialogue box window cliông chồng Add-Ins

*

At the bottom of the window, Select COM Add-ins on the Manage sectionClick on GoFrom the available menu given, clear one of the COM Add-ins and click OK

*

Now double cliông chồng on the Excel workbook or sheet lớn restart the programIf the problem continues, click 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 Click 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 khổng lồ confirm if these add-ins cause the error

*

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

That said, you have successfully learned to solvethere was a problem sending the commvà to the program excel. The problem is comtháng to all users of Windows, so you need not panic. When the error occurs, choose any solution in this guide và solve it in the comfort of your home.Learn more about Microsoft Office errors Here.

If you’re looking for a software company you can trust for its integrity & honest business practices, look no further than huyenkhuong.com. We are a Microsoft Certified Partner và 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, & after all the sales.

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