XL: DDE Links Break When Changed from Manual to Automatic

ID: Q159419

The information in this article applies to:

Microsoft Excel for Windows 95, version 7.0
Microsoft Excel 97 for Windows
Microsoft Windows NT, version 3.51 with Service Pack 5
Microsoft Windows NT, version 4.0

SYMPTOMS

In Microsoft Excel, when you use the Links dialog box to change a link from manual updating to automatic updating, the link may not be updated automatically.

CAUSE

This problem occurs when the following conditions are all true:

The link is a dynamic data exchange (DDE) link to a DDE server program.
```
    -and-
```

You are running either of the following operating systems:

      Windows NT, version 3.51 with Service Pack 5
      Windows NT, version 4.0

You are using Microsoft Excel 7.0 or Microsoft Excel 97.
```
    -and-
```
You change the link from automatic to manual updating before you change the link to automatic updating.

WORKAROUND

To work around this problem, use the following steps:

1. In the Links dialog box, click the link that you want to change

   from manual to automatic updating.

2. Click Automatic.

3. Click Update Now, and then click OK.

STATUS

Microsoft has confirmed this to be a problem in the Microsoft products listed at the beginning of this article.

NOTE: This problem does not occur when under either Windows 95 or Windows NT 3.51 with Service Pack 4.

MORE INFORMATION

In Microsoft Excel, you can create a link to a DDE server program by typing a formula similar to the following:

   =DDEServer|Topic!Value

By default, when you create such a formula, the formula is updated automatically; that is, whenever the DDE server program broadcasts new information, the formula automatically displays the new information.

You can change this behavior by using the Links dialog box (on the Edit menu, click Links). If you click Manual at the bottom of the dialog box, the link is updated only when you click Update Now.

Additional query words: XL97 dynamic data exchange

Keywords          : kbualink97 xlformula offinterop 
Version           : WINDOWS:7.0,97
Platform          : WINDOWS
Issue type        : kbprb

Last Reviewed: January 7, 1999