Updated April 27, 1998

The Third Time's The Charm

Patch For Calculation Bug in Microsoft Excel 97

MICROSOFT HAS finally fixed the auto recalculation bug in Excel 97 that BugNet reported a couple months ago.

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 or columns are inserted into this range of formulas, and
  3. The same formula is entered into the newly inserted row or column

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

Microsoft has posted a fix for the Excel automatic recalculation error at http://www.microsoft.com/Excel/enhancements/
XL8P1.asp?prev=111111. The version of the patch dated April 22 finally fixes both the row and column manifestation of the bug.

-- Bruce Brown

© BugNet material copyright 1994-1999 by BugNet.
® BugNet is a Registered Trademark of KeyLabs.
Astonisher.com material is

© Copyright 1973 - 2015 by Bruce Brown and BF Communications Inc.
Astonisher.com is a trademark of BF Communications Inc.

This historic replica of BugNet from the period 1994-1999
is presented by astonisher.com with the permission of BugNet.

BF Communications Inc.
P.O. Box 393
Sumas, WA 98295 USA
(360) 927-3234

Website by Running Dog

* Here's Bruce Brown's BugNet Memoir...
* Here's the free BugNet from 1999...