XL98: Worksheet Not Recalculated with More Than 240 Formulas in Same Row

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 in the Reference box, and then click OK.
3. Type the following formula, and then press CONTROL+RETURN:

   =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 in the Reference box, and then click OK.
7. Type the following value, and then press CONTROL+RETURN:

   1

If you scroll to the right, you will see that cells HR3:IH3 have not been recalculated.