Workaround For New Calculation Bug in Microsoft Excel 97
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."
About the author
Posted by Ken Colburn of Data Doctors on June 15, 1999
Need Help with this Issue?
We help people with technology! It's what we do.
Contact or Schedule an Appointment with a location for help!