XL97: Formulas Not Refreshed After Data Consolidation

ID: Q186394

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

When you use the Consolidate command on the Data menu, some formulas on your worksheet may not be automatically updated.

CAUSE

This problem may occur when the following conditions are true:

One or more of the source ranges used in the consolidation contain formulas.
```
    -and-
```
The destination range of the consolidation contains formulas.

RESOLUTION

To correct this problem, obtain Microsoft Excel 97 Service Release 2 (SR-2).

For additional information about SR-2, please see the following article in the Microsoft Knowledge Base:

   ARTICLE-ID: Q151261
   TITLE     : OFF97: How to Obtain and Install MS Office 97 SR-2

To work around the problem temporarily, press CTRL+ALT+F9 to recalculate the entire workbook.

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).

MORE INFORMATION

Example of the Problem

To see an example of the problem, follow these steps:

1. Save and close any open workbooks and create a new workbook.

2. Type the following entries into the worksheet:

      A1: 1            B1: 3
      A2: 2            B2: 4
      A3: =SUM(A1:A2)  B3: =SUM(B1:B2)
      A4:              B4:
      A5: 1            B5: 1
      A6: 1            B6: 1
      A7: =SUM(A5:A6)  B7: =SUM(B5:B6)

3. Select cell A5.

4. On the Data menu, click Consolidate.

5. Type "A1:B3" (without the quotation marks) in the Reference box, and

   then click Add. Click OK.

   Note that the formulas in cells A7 and B7 are not recalculated.

Additional query words: XL97 recalc

Keywords          : kbdta xlformula 
Version           : WINDOWS:97
Platform          : WINDOWS
Issue type        : kbbug
Solution Type     : kbfix

Last Reviewed: November 6, 1998