Microsoft KB Archive/266443

= XL: DDE Formulas Produce #NAME? Error in Shared Workbooks =

Article ID: 266443

Article Last Modified on 1/6/2006

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition
 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q266443



SYMPTOMS
During an automatic update of a shared workbooks, Dynamic Data Exchange (DDE) formulas produce #NAME? errors.



CAUSE
This problem occurs when the following conditions are true:
 * 1) You save a workbook as a shared workbook and set the automatic update interval.

-and-
 * 1) Another user enters a DDE formula.

When the workbook automatically updates, the cell that contains the DDE formula is not updated on other users' systems. Instead, the cell displays a #NAME error, and all information up to and including the pipe symbol (|) is missing in the formula bar.



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 truncate cut clipped error

Keywords: kbprb kbpending KB266443

-

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

© Microsoft Corporation. All rights reserved.