Formula Cell not updating

[Guest]

I have a workbook with several worksheets in it. The sheets are not related
to each other except that I used the copy worksheet feature to add sheets.
There is a formula cell which totals the two cells to the immediate left on
each worksheet. For some reason, when I change one of the values in the
cells being added, it doesn't update the total, unless I retype the formula
in the cell. I have had this problem one other time in the past.

I'm not sure how to fix it.

 

[Frank Kabel]

Hi
you may check if automatic calculation is enabled ('Tools - Options -
Calculate')