XL97: Worksheet Not Recalculated with > 240 Formulas in Same Row

ID: Q191661

The information in this article applies to:

Microsoft Excel 97 for Windows

SYMPTOMS

When you calculate values in your Microsoft Excel worksheet, some cells may not be automatically recalculated.

CAUSE

This problem may occur when you enter the same formula in more than 240 columns in the same row.

RESOLUTION

To correct this problem, obtain and install Microsoft Office 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 temporarily work around this problem, press CTRL+ALT+F9 to completely recalculate all open workbooks in Microsoft Excel.

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. On the Edit menu, click Go To. In the Go To dialog box, type "B3:IH3"

   (without the quotation marks) in the Reference box, and then click OK.

3. Type the following formula, and then press CTRL+ENTER:

      =B1+B2

   Note that the formula is entered into the range B3:IH3.

4. Save, and then close the file.

5. Open the file that you saved in step 4.

6. On the Edit menu, click Go To. In the Go To dialog box, type "B2:IH2"

   (without the quotation marks) in the Reference box, and then click OK.

7. Type the following value, and then press CTRL+ENTER:

If you scroll to the right, you will see that cells HR3:IH3 have not been 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