if the data is being entered in the wrong cell, You should concider
protecting cells except those available for data entry.

Being a klutz, I do this even on stuff I do only for myself.

"Thomas Jacob" wrote:

I have a work book that has data containing formulas. while editing the
same , on some cells, it was found that the formula is getting lost during
data entry....Can some one help me on this please......