Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Remote DDE link in an embedded workbook does not update values properly


View products that this article applies to.

This article was previously published under Q282137

↑ Back to the top


Symptoms

When you open a Microsoft Word 2002 document that contains an embedded Microsoft Excel 2002 worksheet, which, in turn, contains a remote Dynamic Data Exchange (DDE) link in one of its cells, the DDE link to the client data source does not update the cell's values properly.

↑ Back to the top


Cause

This behavior occurs because the embedded Excel worksheet's Update Remote References setting is lost when the Word document is saved.

↑ Back to the top


Workaround

To work around this issue, reselect Update Remote References when you open the Word document. To do this, follow these steps:
  1. Start Microsoft Word.
  2. On the File menu, click Open, and then browse to and select the Word document that contains the embedded Excel worksheet.
  3. Click the Open button.
  4. When the document opens, double-click the embedded worksheet object.
  5. On the Tools menu, click Options.
  6. Click the Calculation tab, and then click to select the Update Remote References check box.
  7. Click OK.

↑ Back to the top


Status

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

↑ Back to the top


Keywords: KB282137, kbpending, kbbug

↑ Back to the top

Article Info
Article ID : 282137
Revision : 5
Created on : 5/21/2007
Published on : 5/21/2007
Exists online : False
Views : 373