Formula won't reflect new cell data

[D'oug]

I think I accidentally hit a key command and now when I create a formula (say
just adding a column of numbers), if I go back and change one of those
numbers in the column, the Total doesn't update.

Any help greatly appreciated

 

[Peo Sjoblom]

Tools>options>calculation and set it to automatic

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)