When you cut data from a location, you sever the relative references so that
when you paste it to the new location the links to that cell cannot make the
connection and result in the #REF! error. Don't ask me why. That was the
way MS designed it.

"F. Lawrence Kulchar" wrote:

How come the following occurs:

In cell A1, I have the word "NAME" entered (w/o the quotes)

In cell B1, I have "=A1" typed and all is perfect...."NAME" appears in B1.

Then, if from cell C1, where "ROBIN" is typed, I hit "CTRL C" and "CTRL V"
into cell A1...and all is fine...in cell B1, I instantly get "ROBIN".

BUT, IF, INSTEAD, I TYPE IN CELL C1 "CTRL X" and then "CTRL V" into cell
A1...
ALL IS NOT FINE...

B1 appears #REF1" error...because instead of copying and
pasting into A1, I X'ed out and pasted, the error, "#REF!" appears in B1.

Please explain and thanks,

FKulchar