Formula Cell not updating

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Hi
you may check if automatic calculation is enabled ('Tools - Options -
Calculate')
 
Back
Top