linked file not found

A

amag

Hi,
I cut pasted some data in workbook sheet A from another workbook sheet
B and then deleted workbook B.

When I click on the cell it refers to workbook B, in fact gives me the
full path of the value. The file is no longer there. I cant find it
using windows search on the whole disk. Does anyone have any idea, what
is going on?

TIA/amag
 
C

CLR

It appears that you have only copied a link to the data, not the data itself.
If you have not deleted the file from your RecycleBin, then restore it and
then Copy > PasteSpecial > Values again to re-capture the data.

hth
Vaya con Dios,
Chuck, CABGx3
 
A

amag

Tks for ur response ...
I understand that I might have copied a link to the data but it should
be referring to some file and capturing data from there. The problem is
I cant find that file on the disk.
-amag
 
C

CLR

When you delete the source of a link, you do not automatically delete all
references to it......the source is gone....the link still
exists............the only way to retrieve the original data is to get it
from the old source if it's still alive in the recycle bin, or some other
saved version somewhere.............

Vaya con Dios,
Chuck, CABGx3
 
Top