copying formulas - bizarre result 1

[stoke]

hi all,

sheet 1, a1 is linked to sheet 2, a1, whose cell refs have been made absolute.
if i return the cell refs to relative, and then copy (or paste special formulas) sheet 1, a1 to sheet 1, a2 then i get the correct formula , ie it reads =, but the wrong result.
in this case the reference sheet 2, a2 but the result is that which is shown in shhet 2, a1 !!!!!!!

if anybody can shed light on this one then please let me know!

Thanks,

 

[GlennUK]

Check that calculation mode is set to Automatic, using menu command Tools/Options/Calculation, as it sounds as though the new formula is not being recalculated.

Glenn.

 

[stoke]

Glenn,

Thanks - much appreciated!
nice and simple but saved me a lot of head-scratching!

Cheers,