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

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:

Start Microsoft Word.
On the File menu, click Open, and then browse to and select the Word document that contains the embedded Excel worksheet.
Click the Open button.
When the document opens, double-click the embedded worksheet object.
On the Tools menu, click Options.
Click the Calculation tab, and then click to select the Update Remote References check box.
Click OK.