Have you got the calculation mode set to manual (ToolsOptionsCalculation)?

--
__________________________________
HTH

Bob

"mint" wrote in message
...
I have a formula something like this =ROUND(I34/$J$29,0)

Copied the formula a column of cells and it turn out well as in
=ROUND(I35/$J$29,0) , =ROUND(I36/$J$29,0) , =ROUND(I37/$J$29,0). But even
though the formula has changed, the end value is still the same at the
original cell

Please Help