Try,

Tools|Options|Calculation and select automatic

Mike

"SilviaG" wrote:

I have a spreadsheet where i have simple adding and subtracting formulas but
when i enter any value on the cells the formula doesnt calculate it, i have
to double click the the cell with the formula in order for it to calculate
it. Any help on how to get rid of that?

ex
A1=5
A2=3
A3 = SUM(A1,A2) bUT I HAVE TO DOUBLE CLICK A3 IN ORDER FOR THE FORMULA TO
CALCULATE THE SUM OF A1 AND A2