Assuming you aren't working with closed workbooks, you could always use the
INDIRECT function in your formulas, i.e:

instead of =A1+B1
it would be =INDIRECT("A1")+INDIRECT("B1")
--
John C


"Cleve" wrote:

I have locked and protected a worksheet leaving only "Select unlocked cells"
checked. The problem is that if a user "moves" an entry in an unlocked cell,
either by ctrl X or drag and drop the cell references in the locked formulae
that referred to the original position change to the new position. Is there
any way of preventing this without turning off the drag and drop
functionality?