Microsoft KB Archive/175050

= XL97: Recalculating Displays Values from Another Workbook =

Article ID: 175050

Article Last Modified on 10/22/2000

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q175050





SYMPTOMS
When you recalculate your Microsoft Excel workbook, some of the values in the workbook may appear in another open workbook.



CAUSE
This problem may occur if the following conditions are true:
 * The workbook contains several DDE links to other programs. -and-


 * The workbook contains formulas.



RESOLUTION
To correct this problem, obtain Microsoft Excel 97 Service Release 2 (SR-2). For additional information about SR-2, please click the article number below to view the article in the Microsoft Knowledge Base:

151261 OFF97: How to Obtain and Install MS Office 97 SR-2

To work around this behavior temporarily, cycle through the workbooks after they are open. By doing this, you prevent the data in the workbooks from "bleeding through" from one workbook to the other.



STATUS
Microsoft has confirmed this to be a problem in Microsoft Excel 97 for Windows. This problem was corrected in Microsoft Office 97 Service Release 2 (SR-2).

Additional query words: XL97 XL2000

Keywords: kbbug kbfix kbui KB175050

-

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

© Microsoft Corporation. All rights reserved.