XL2000: DDE Links in Embedded Excel Object Do Not Update

When you open an embedded Excel document that contains a Dynamic Data Exchange (DDE) Link, the link does not automatically update. Additionally, the following problems occur.

Update Now

When you click Update Now in the Links dialog box to force the DDE link to update, the link still does not continue to automatically update.

Update Remote References

When you open the document containing the Excel worksheet object, the Update remote references check box is not selected although you had previously saved the document with this option selected.

This problem occurs when you copy or insert an Excel worksheet object into another document, such as a Microsoft Word document, and the Excel object contains a DDE link.

WARNING: If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

To correct this problem, add the EmbedUpdateRemoteReferences registry entry to the Excel Options subkey. To add this new registry entry:

1. On the Start menu, click Run. In the Open box, type regedit and press RETURN to start Registry Editor.
2. In the left pane of Registry Editor, locate and select the following subkey (folder):
   HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options
3. On the Edit menu, point to New and then click DWORD Value.
4. Type EmbedUpdateRemoteReferences, and then press ENTER.
5. Double-click the EmbedUpdateRemoteReferences icon.
6. In the Value data box, type 1, and then click OK.
7. Quit Registry Editor.

To update the embedded Excel object, double-click the worksheet object. When the following dialog box appears, click Yes. When you click Yes, the DDE link continues to automatically update.

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.