excel copy paste problem

[elhann0n]

copying the formula sum(a1:a3) from a4 to b4 does show sum(b1:b3) in the b4 cell, but, value is still the same as a4. Changing a character (eg deleting and reentering the 3 in sum(b1:b3)) gets the correct value.

 

[Alabalcho]

Check "Recalculation" options, you might have turned them off.