XL2000: DDE Links in Embedded Excel Object Do Not Update (215189)


The information in this article applies to:

  • Microsoft Excel 2000
This article was previously published under Q215189
IMPORTANT: This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry

SYMPTOMS

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.

CAUSE

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.

RESOLUTION

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.
The workbook you opened contains automatic links to information in another workbook. Do you want to update this workbook with changes made to the other workbook?
When you click Yes, the DDE link continues to automatically update.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.
Modification Type:MajorLast Reviewed:10/6/2003
Keywords:kbbug kbDDE kbpending KB215189
©2003 Microsoft Corporation. All rights reserved.