Microsoft KB Archive/215189

= XL2000: DDE Links in Embedded Excel Object Do Not Update =

Article ID: 215189

Article Last Modified on 10/6/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



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:  On the Start menu, click Run. In the Open box, type regedit and press RETURN to start Registry Editor. In the left pane of Registry Editor, locate and select the following subkey (folder):

HKEY_CURRENT_USER\Software\Microsoft\Office\9.0\Excel\Options

 On the Edit menu, point to New and then click DWORD Value. Type EmbedUpdateRemoteReferences, and then press ENTER. Double-click the EmbedUpdateRemoteReferences icon. In the Value data box, type 1, and then click OK.</li> Quit Registry Editor.</li></ol>

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.

<div class="status_section">

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

Additional query words: XL2000 hot link cold

Keywords: kbbug kbdde kbpending KB215189

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.