When I add a new data value and the copy the formulae from the line above, the resulting answer does not update but shows the original value

[popsrowe]

D43=20,E43 = (D43*$E$42)
D44=25,E44 = (D44*$E$42) but E44 still shows original E43 value.

[mikekaganski]

Menu Data-Calculate-AutoCalculate