ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Broken Limks (https://www.excelbanter.com/excel-worksheet-functions/58517-broken-limks.html)

Minitman

Broken Limks
 
Greetings,

When I open my workbook I get this error message about broken links,
When I try to fix the links I get a list of all of the links but no
cell location of where the links are located. From this list, I can
break the link or redirect it. I tried to break the links. One would
not be broken (the window list the errant links with Source, Type,
Update and Status. The links with a status of "Error: Source not
found" are the ones that will not break their links). I got out of
that window and tried to find this errant link. I went to find set
the search to do the whole workbook, but Find found nothing.

Is there anyway to find this link so that I can remove it?

TIA

-Minitman

Dave Peterson

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

Minitman wrote:

Greetings,

When I open my workbook I get this error message about broken links,
When I try to fix the links I get a list of all of the links but no
cell location of where the links are located. From this list, I can
break the link or redirect it. I tried to break the links. One would
not be broken (the window list the errant links with Source, Type,
Update and Status. The links with a status of "Error: Source not
found" are the ones that will not break their links). I got out of
that window and tried to find this errant link. I went to find set
the search to do the whole workbook, but Find found nothing.

Is there anyway to find this link so that I can remove it?

TIA

-Minitman


--

Dave Peterson

Minitman

Broken Limks
 
Hey Dave,

I'll give that a try.

-Minitman



On Fri, 02 Dec 2005 23:33:12 -0600, Dave Peterson
wrote:

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

Minitman wrote:

Greetings,

When I open my workbook I get this error message about broken links,
When I try to fix the links I get a list of all of the links but no
cell location of where the links are located. From this list, I can
break the link or redirect it. I tried to break the links. One would
not be broken (the window list the errant links with Source, Type,
Update and Status. The links with a status of "Error: Source not
found" are the ones that will not break their links). I got out of
that window and tried to find this errant link. I went to find set
the search to do the whole workbook, but Find found nothing.

Is there anyway to find this link so that I can remove it?

TIA

-Minitman




All times are GMT +1. The time now is 07:13 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com