How Can I remove Dead Links ???

Dan Thompson · External Since: Sep 13, 2005 Posts: 4

I have a workbook that had some old links in it. I rebuilt all the sheets
with new links and deleted the old ones but yet every time I open the work
book it still is looking for old links I don't understand. And when I go to
EDIT -> LINKS you know to show which workbooks the one I have open is linked
to, anyhow it still shows that it is linked to old workbooks that do not
exist anymore because I have deleted them. How can I change this so my
workbook is not looking for the dead links ??
Help !

Dan Thompson

Dave Peterson · External Since: Jul 08, 2005 Posts: 15610

Bill Manville's FindLink program:
http://www.oaltd.co.uk/MVP/Default.htm

Dan Thompson wrote:
>
> I have a workbook that had some old links in it. I rebuilt all the sheets
> with new links and deleted the old ones but yet every time I open the work
> book it still is looking for old links I don't understand. And when I go to
> EDIT -> LINKS you know to show which workbooks the one I have open is linked
> to, anyhow it still shows that it is linked to old workbooks that do not
> exist anymore because I have deleted them. How can I change this so my
> workbook is not looking for the dead links ??
> Help !
>
> Dan Thompson

--

Dave Peterson

Dan Thompson · External Since: Sep 13, 2005 Posts: 4

Thanks Dave That XLA Add-in Totally Worked.

"Dave Peterson" wrote:

> Bill Manville's FindLink program:
> http://www.oaltd.co.uk/MVP/Default.htm
>
> Dan Thompson wrote:
> >
> > I have a workbook that had some old links in it. I rebuilt all the sheets
> > with new links and deleted the old ones but yet every time I open the work
> > book it still is looking for old links I don't understand. And when I go to
> > EDIT -> LINKS you know to show which workbooks the one I have open is linked
> > to, anyhow it still shows that it is linked to old workbooks that do not
> > exist anymore because I have deleted them. How can I change this so my
> > workbook is not looking for the dead links ??
> > Help !
> >
> > Dan Thompson
>
> --
>
> Dave Peterson
>

Dan Thompson · External Since: Sep 13, 2005 Posts: 4

Thanks Dave that XLA Add-in Totally worked.

"Dave Peterson" wrote:

> Bill Manville's FindLink program:
> http://www.oaltd.co.uk/MVP/Default.htm
>
> Dan Thompson wrote:
> >
> > I have a workbook that had some old links in it. I rebuilt all the sheets
> > with new links and deleted the old ones but yet every time I open the work
> > book it still is looking for old links I don't understand. And when I go to
> > EDIT -> LINKS you know to show which workbooks the one I have open is linked
> > to, anyhow it still shows that it is linked to old workbooks that do not
> > exist anymore because I have deleted them. How can I change this so my
> > workbook is not looking for the dead links ??
> > Help !
> >
> > Dan Thompson
>
> --
>
> Dave Peterson
>