linked file not found

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

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
>
>

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
> >
> >

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
> > >
> > >
>

Bill Manville's Add-in called "FindLinks" may be of some help to you....it's
available at

http://www.acctadv.com/exceldownloads.php

Vaya con Dios,
Chuck, CABGx3



"CLR" wrote:

> 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
> > > >
> > > >
> >
>
>
>