Article ID: 175050 - Last Review: October 22, 2000 - Revision: 1.0

XL97: Recalculating Displays Values from Another Workbook

Retired KB ArticleRetired KB Content Disclaimer
View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
This article was previously published under Q175050
Expand all | Collapse all

SYMPTOMS

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

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.
Back to the top

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  (http://support.microsoft.com/kb/151261/EN-US/ ) 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.
Back to the top

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).
Back to the top
APPLIES TO
  • Microsoft Excel 97 Standard Edition
Back to the top
Keywords: 
kbbug kbfix kbui KB175050
Back to the top
Retired KB ArticleRetired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
Back to the top