Problems with the copy down formula

[tackp]

am experiencing problems when copying down a formula. The formula retains
the value of the first cell throughout he entire selected range. Any idea as
to why this is happening?

 

[Frank Kabel]

Hi
check if automatic calculation is enabled ('Tools - Options-
Calculation')

 

[mzehr]

Hi,
Try:
goto 'Tools - Options - Calculation' and check 'Automatic calculation'