I would guess that calculation mode is set to manual.

Try setting to automatic.


Gord Dibben MS Excel MVP

On Thu, 29 Mar 2007 12:14:00 -0700, Preston
wrote:

For two months I've used Excel 2007 with no problem, but this week I noticed
a bug with the anchor function. When I would anchor a cell and copy down the
formula, it would repeat the same number from the first cell, but update the
formula. Also, after I copied all the cells and used the =sum() at the bottom
of the column, whenever I would delete or change any of the cells within the
sum range, the sum would not change.
What is going on with Excel? I never had this happen with 2003.