problem with replicate formula

When i replicate a formula the formula is correctly changed using relative
cell addressing, however rather than calculating the new value it copies the
original value.

Tools>Options>Calculation, check Automatic

--
Kind regards,

Niek Otten

"rfoster6" <[email protected]> wrote in message
news:[email protected]...
> When i replicate a formula the formula is correctly changed using relative
> cell addressing, however rather than calculating the new value it copies
> the
> original value.