Agnes,

When you cut and paste, it is possible to lose data. Are you getting #REF
or anything similar to that? I might suggest when you cut and past, then
paste special, this will leave all the formula's in tact.

"Cannot copy and paste an excel formula" wrote:

I am unable to copy and paste a formula from one cell to another. This is
rather weird and something I have not encountered before. I will appreciate
some help.

Thanks,
Agnes