Workaround For New Calculation Bug in Microsoft Excel 97

Question

Workaround For New Calculation Bug in Microsoft Excel 97

Answer

This question was answered on June 15, 1999. Much of the information contained herein may have changed since posting.

MICROSOFT HAS confirmed the existence of a new calculation bug in Excel 97 According to Microsoft, "in Microsoft Excel 97, some formulas on a worksheet may not be recalculated automatically This behavior may occur even if you choose to use automatic calculation for formulas in the worksheet." The problems can occur when:

1 The user creates a block of formulas all at once (e.g using AutoFill), and

2 new rows are inserted into this range of formulas, and

3 The same formula is entered into the newly inserted row

In the meantime, the temporary workaround is to re-fill down the formula by selecting the cells above, drag the Fill Handle Down to the cell that is not calculating correctly

You can also correct the problem by selecting cell A1 and choosing Edit, Replace, Enter and typing "=" (without the quotes) in both the "Find What" and "Replace With" edit boxes, and then selecting Replace All

This re-enters the formulas Microsoft says, "Please note that by re-entering the formulas, the issue is fixed within the affected worksheet and will not occur again."

Need Help with this Issue?

We help people with technology! It's what we do.
Schedule an Appointment with a location for help!

Author

Posted by Ken of Data Doctors on June 15, 1999