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


"amag" <amitntu@gmail.com> wrote in message
news:1152765006.104962.23190@i42g2000cwa.googlegroups.com...
> 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
>
> CLR wrote:
>
> > 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
> >
> >
> >
> > "amag" wrote:
> >
> > > 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
> > >
> > >
>