Formula won't reflect new cell data

D

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
 
P

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)
 
Top