Hi Barb,

Just figured it out. I have selected in dataOptionsCalculation as manual
insted of automatic. When i click automatic everything came back to normal.


"Barb Reinhardt" wrote:

Is it possible that the worksheet is protected and you are copying from a
locked cell?
--
HTH,

Barb Reinhardt



"Suri" wrote:

HI,

I was trying to copy the formula in one cell toanother.
Eg: Copy formula "=T157*H157" in cell c5 in to cell C6.

When i drag the formula from cell C5 to C 6 it copy paste as a value. not as
a formula. Didnt have this problem until today. How can i fix this?
Can anyone please help.

Kind Regards,
Suri