Search workbook for links

[VegasNath]

How can I search a workbook for external links, without removing them?

Idealy, I need to remove the external link, but maintain the worksheet and cell link, but in the active workbook.

[SammyB]

Try http://j-walk.com/ss/excel/usertips/tip054.htm" onclick="window.open(this.href);return false;

[HansV]

Or use Bill Manville's free add-in Findlink.xla from Office Automation Ltd. - The Excel MVP Page.

[VegasNath]

Edit | Links | Change Source was greyed out. The links were to a temporary file I was using from email. Luckily, there were only 3 links and Bill's add-in found them immediately.

Many Thanks to you both.

[ChrisGreaves]

How can I search a workbook for external links, without removing them?

This morning I found This pageto be quite helpful.