how do you find external links in a multi-workbook file?

[berbes]

how do you find external links in a multi-workbook file? there's got to be an easier way than cell by cell, worksheet by worksheet, right??

my blisters thank you!
jackie

 

[MarkAndrews]

I know you can use DominicB's add in for this (Download from his webpage)

However, it only shows that there are links, not where they are

 

[MarkAndrews]

http://www.dom-and-lis.co.uk/

Install the freeware add in (using instructions)

Look in Cells > Find & Remove Links (You have the option not to remove links when clicked)

HTH

 

[berbes]

thanks so much, mark...BEST help out there, hands down.

 

[berbes]

i can't find where to look for 'cells>' to find and remove links. thanks for taking this extra time for me, mark (or anyone!!!).

 

[berbes]

i can't find where to look for 'cells>' to find and remove links. thanks for taking this extra time for me, mark (or anyone!!!). i installed the add-in just fine, but still stuck.

 

[MarkAndrews]

You Have Private Message