Rod from Corrections wrote...
....
Is there a way to turn off the ability to paste data into the worksheet, and
to force each field to be completed manually? This would eliminate the
problem.

Unfortunately, there's no way to disable pasting into any unlocked cell
(sorry, that the correct Excel terminology, even though it means
something quite different where you work).