You probably have Calculation set to manual. You can hit F9 to recalculate
at any time. Or, you can set Calculation to automatic.

Tools-Options-Calculation (tab)...select Automatic.

HTH,
Paul

"timc" wrote in message
...
i am copying a relative formula from one cell to another. when i paste the
copy i get the same answer as the original cell. this happens with a new
file and different computer/program. when i hilite the clone cell and hit
return, the correct answer shows. the formula is simple and is generated
from the formula wizard (i.e.: ln(A5)). the answer for the A5 reference
shows up in all clones cells.