XL: DDE Links Break When Changed from Manual to Automatic

• Microsoft Excel for Windows 95, version 7.0
• Microsoft Excel 97 for Windows
• Microsoft Windows NT Workstation versions 3.51, SP5
• Microsoft Windows NT 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 

Additional query words: XL97 dynamic data exchange

Keywords : kbualink97 xlformula offinterop
Version : WINDOWS:97; Win95:7.0; winnt:3.51,4.0,SP5
Platform : Win95 WINDOWS winnt
Issue type : kbprb