Lỗi there was a problem of sending command năm 2024
Excel là một phần mềm được tích hợp trong bộ công cụ văn phòng Microsoft Office, thường dùng để tính toán các só liệu dựa trên các hàm cơ bản. Và cũng như các phần mềm khác, Excel cũng có rất nhiều lỗi khác nhau, một trong những lỗi phổ biến nhất là bạn không thể mở được file Excel sau khi tải trên mạng về và màn hình hiển thị thông báo There was a problem sending a command to the program. Hôm nay, Quản Trị Mạng sẽ hướng dẫn các bạn khắc phục lỗi rất hay gặp trên Excel này. Show
Bước 1: Bạn mở file Excel không bị lỗi lên, click vào biểu tượng Office ở góc trên bên trái, chọn Excel Options Bước 2: Trong hộp thoại Excel Option, các bạn chọn Advanced ở cột bên trái rồi kéo xuống mục General, bỏ tick ở ô Ignore other applications that use Dynamic Data Exchange. Cuối cùng nhấn OK là xong. Bây giờ, các bạn mở lại file đó bình thường rồi nhé. Đơn giản phải không các bạn,chỉ với 3 bước cơ bản trên bạn đã sửa được lỗi There was a problem sending a command to the program. Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support. "An error occurred when sending commands to the program" in Excel
In this articleSymptomsYou receive the following error message in Microsoft Excel. This error indicates that some process that is running inside Excel will not let Excel close. An error occurred when sending commands to the program ResolutionTo resolve this problem, try the following methods, as appropriate, in the given order. Method 1: Ignore DDETo correct this setting, follow these steps:
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 Excel. This message instructs Excel to open the workbook that you double-clicked. If you select the "Ignore" option, Excel ignores DDE messages that are sent to it by other programs. Therefore, the DDE message that is sent to Excel by Windows Explorer is ignored, and Excel does not open the workbook that you double-clicked. Note For more information about how to turn off DDE, see the following Microsoft Knowledge Base article: 211494 "There was a problem sending the command to the program" error in Excel If these steps do 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 Microsoft User Experience Virtualization 2.0 (KB2927019). If you are not sure whether you are running UE-V, examine the program list in the Programs and Features item in Control Panel. An entry for "Company Settings Center" indicates that you are running UE-V. If these steps do not resolve the problem, go to Method 3. Method 3: Reset file associationsTo check whether the file associations in the system are performing correctly, reset the Excel file associations to their default settings. To do this, follow the steps for your operating system.Windows 10
Windows 8
Windows 7
If these steps do not resolve the problem, go to Method 4. Method 4: Repair OfficeTry to repair your Office programs. To do this, follow the steps for your installation type and operating system. For a Microsoft 365 Click-to-Run installation Windows 10
Note You may have to restart your computer after the repair process is completed. Windows 8
Note You may have to restart your computer after the repair process is finished. Windows 7
Note You may have to restart your computer after the repair process is complete. 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 do not resolve the problem, go to Method 5. Method 5: Turn off add-insExcel and 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 do this, follow these steps:
If Excel loads the file, 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 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 to use the add-in, you can leave it turned off. If Excel does not open the file after you turn off all the add-ins, the problem has a different cause. If these steps do not resolve the problem, go to Method 6. Method 6: Disable hardware accelerationTo work around this problem, disable hardware acceleration until a fix is released by your video card manufacturer. Make sure to check regularly for updates to your video card driver. To disable hardware acceleration, follow these steps:
If these steps do not resolve the problem, go to Method 7. Method 7: Verify or install the latest updatesYou may have to set Windows Update to automatically download and install recommended updates. Installing any important, recommended, and optional updates can frequently correct problems by replacing out-of-date files and fixing vulnerabilities. For more information about Office updates, click the following article number to go to the article in the Microsoft Knowledge Base: Office Updates Microsoft Support More InformationThere are many possible reasons that might lead to this error.
For more information about this problem and for additional troubleshooting steps, see the following Microsoft 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 Troubleshoot Excel opening blank when you double-click a file icon or file name |