If you wish to disable Dynamic Data Exchange or DDE in Excel, here is all the information you need about this protocol and how to deactivate it. There are three methods to accomplish this – using Excel Options, the Local Group Policy Editor, or the Registry Editor.
What is Dynamic Data Exchange Server in Excel?
Dynamic Data Exchange Server is a protocol used to exchange data between two or more applications, including Excel itself. For example, if you link an Excel file to a Word document and the DDE Server protocol is enabled, the embedded file in Word will update automatically when changes are made to the Excel spreadsheet.
If you don’t want this auto-update functionality and want the data to remain as it was at the time of embedding, disabling the Dynamic Data Exchange Server is the best course of action.
How to disable Dynamic Data Exchange in Excel
Follow these steps to turn off Dynamic Data Exchange in Excel:
- Open the Excel app.
- Click on the Options menu.
- Go to Trust Center > Trust Center Settings > External Content.
- Locate the Enable Dynamic Data Exchange Server Lookup setting.
- Uncheck the checkbox.
- Click the OK button.
To learn more about these steps, continue reading.
Begin by opening the Excel app on your computer and clicking on the Options menu. Then, switch to the Trust Center tab and click the Trust Center Settings button.
Next, navigate to the External Content tab and find the Enable Dynamic Data Exchange Server Lookup option.
Uncheck the corresponding checkbox and click the OK button.
How to disable Dynamic Data Exchange in Excel using Group Policy
To disable Dynamic Data Exchange in Excel using Group Policy, follow these steps:
- Press Win+R > type msc and click the OK button.
- Navigate to Trust Center > External Content in User Configuration.
- Double-click on the Don’t allow Dynamic Data Exchange (DDE) server lookup in Excel setting.
- Select the Enabled option.
- Click the OK button.
Let’s delve into these steps in detail.
Note: In order to use this method, you must install the Administrative Templates for Office.
To get started, press the Win+R buttons simultaneously to open the Run prompt. Then, type gpedit.msc and click the OK button to open the Local Group Policy Editor. Next, navigate to the following path:
User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > Security > Trust Center > External Content
Here, you will find a setting named Don’t allow Dynamic Data Exchange (DDE) server lookup in Excel. Double-click on this setting and select the Enabled option.
Finally, click the OK button to save the change.
How to disable Dynamic Data Exchange in Excel using Registry
To disable Dynamic Data Exchange in Excel using the Registry, follow these steps:
- Search for regedit in the Taskbar search box.
- Click on the corresponding search result and click the Yes button.
- Navigate to office16.0excelsecurity in HKCU.
- Right-click on security > New > Key and name it external content.
- Right-click on external content > New > DWORD (32-bit) Value.
- Name it disableddeserverlookup.
- Double-click on it to set the Value data as 1.
- Click the OK button.
- Restart your computer.
Let’s find out more about these steps.
First, search for regedit in the Taskbar search box, click on the corresponding search result, and click the Yes button to open the Registry Editor.
Once open, navigate to this path:
HKEY_CURRENT_USERSoftwarePoliciesMicrosoftoffice16.0excelsecurity
If you can’t find this path, you need to create it manually. In that case, navigate to the following path:
HKEY_CURRENT_USERSoftwarePoliciesMicrosoft
Then, create the sub-keys accordingly.
If you can find the first path, right-click on security > New > Key and name it external content.
Next, right-click on external content > New > DWORD (32-bit) Value and name it disableddeserverlookup.
Double-click on it and set the Value data as 1, then click the OK button.
Finally, close all windows and restart your computer.
How can I disable the DDE server?
To disable DDE server lookup in Excel, first open the Excel Options wizard. Then, go to Trust Center > Trust Center Settings > External Content. Locate the Enable Dynamic Data Exchange Server lookup option and uncheck the checkbox. Finally, click the OK button to save the change.
How can I enable Dynamic Data Exchange in Excel?
To enable Dynamic Data Exchange in Excel, open the Local Group Policy Editor first. Then, go to the following path: User Configuration > Administrative Templates > Microsoft Excel 2016 > Excel Options > Security > Trust Center > External Content. Double-click on the Don’t allow Dynamic Data Exchange (DDE) server lookup in Excel setting and select the Not Configured option. Click the OK button to save the change.
Read: Microsoft Excel cannot access the file