Question about links

[Fausto Arinos Barbuto]

Hello,

One of my workbooks has a link to another, even though I have
long removed the cell(s) that was(were) linking one workbook
to the other. This ghost link doesn't cause any problem, but I
know it is not there and everytime I open one of these workbooks
I get a message box that shouldn't pop up. Any ideas about what
I should do to remove this dead link once and for all? It is not
the 1st time this happens to one of my workbooks.

Thanks,

---Fausto

[Barrie Davidson]

Have a look at
http://j-walk.com/ss/excel/usertips/tip054.htm
it might be of some help.

[Dave Peterson]

When I can't find links, I'll use Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Fausto Arinos Barbuto wrote:
>
> Hello,
>
> One of my workbooks has a link to another, even though I have
> long removed the cell(s) that was(were) linking one workbook
> to the other. This ghost link doesn't cause any problem, but I
> know it is not there and everytime I open one of these workbooks
> I get a message box that shouldn't pop up. Any ideas about what
> I should do to remove this dead link once and for all? It is not
> the 1st time this happens to one of my workbooks.
>
> Thanks,
>
> ---Fausto

--

Dave Peterson

[Fausto Arinos Barbuto]

Thanks a lot, Dave. This little app solved my problem.

---Fausto


"Dave Peterson" <[email protected]> wrote in message
news:[email protected]...
> When I can't find links, I'll use Bill Manville's FindLink program:
> http://www.oaltd.co.uk/MVP/Default.htm
>
> Fausto Arinos Barbuto wrote:
> >
> > Hello,
> >
> > One of my workbooks has a link to another, even though I have
> > long removed the cell(s) that was(were) linking one workbook
> > to the other. This ghost link doesn't cause any problem, but I
> > know it is not there and everytime I open one of these workbooks
> > I get a message box that shouldn't pop up. Any ideas about what
> > I should do to remove this dead link once and for all? It is not
> > the 1st time this happens to one of my workbooks.
> >
> > Thanks,
> >
> > ---Fausto
>
> --
>
> Dave Peterson

[Fausto Arinos Barbuto]

Very interesting and useful link. And indeed, my problem was due
to a dead "Name". But I wouldn't be able to find it without the
use of Bill Manville's FindLink program, as suggested by Dave.

Thanks for your help.

---Fausto


"Barrie Davidson" <[email protected]> wrote in message
news:[email protected]...
>
> Have a look at
> http://j-walk.com/ss/excel/usertips/tip054.htm
> it might be of some help.
>
>
> --
> Barrie Davidson
>
>
> ------------------------------------------------------------------------
> Barrie Davidson's Profile: http://www.excelforum.com/member.php...o&userid=16930
> View this thread: http://www.excelforum.com/showthread...hreadid=387303
>