#REF! after cut and paste XL2K

  • Thread starter Thread starter MIke
  • Start date Start date
M

MIke

I have a reference in sheet2 to a list of cells in sheet1.
Everytime I paste numbers into the referenced cell of
sheet1, sheet2 gives me the #REF! error. MSExcel help says
the fix is to hit the undo button, but that is not an
option. I want to be able to paste values into sheet1 and
have the reference in sheet2 update its value. Is this
easily possible? The formula that I'm using in sheet2 is
='sheet1'!D8

Any help would be greatly appreciated.

Thanks in advance.
 
Can you do a copy|paste instead of Cut|paste? Then go back and clean up your
original range.
 
Back
Top