I’ve been using the released version of Excel 2007 and I have discovered a bug. I only discovered it yesterday but it is incredibly annoying.
Cells that are calculated based upon the contents of other cells do not update automatically when those cells change. For example, in the attached image (1), I typed in 1 – 10 in a list and then used the Sum command to add them all up.
The answer is 55, which is correct, and that appears in image (2).
Next, in image (3) I change the value of cell A10 from 10 to 15 and pressed enter. Note that the contents of A11 still says =SUM(A1:A15) and the contents of A10 have changed from 10 to 15, but the calculation of A11 still remains the same as if I never changed anything.
It does not update automatically until I go to the cell contents (ie, right beneath font) and press Enter.
This bug renders Excel almost unusable.
Leave a Reply