Finding whereabouts of external links

[lotusman]

I accidentally linked an excel file of mine to some other one (also one of mine). So, when I open it, it says "This file contains links to . . . some other files that could be unsafe..." Then you can Update the Links, or else Break the links. I see that the menu selection, Data, Edit Links, shows you the file name that is external and linked to the current file. But does anyone know (it's a big file I have, lots of formulas) how I could find the cell references, in the current file, that have links to the external file(s)? That way, I could evaluate the usefulness or not of the links, and make sure I made the right changes. I suspect I'll want to edit these cells so that there's no more external linkage, but if I just choose to Break the links I'll never (very easily) know what cells were involved. Hope someone can help me here. Thanks,
Lotusman

[JLGWhiz]

One way is on the ribbon under 'Formulas' to click the 'Show Formulas' button and then you can see which ones have external links.

[Pete_UK]

You might also want to look at any named ranges that you might have set up, using Name Manager on the Formulas tab, as some of these might be pointing to other files.

Hope this helps.

Pete

[shg]

Bill Manville has an add-in called FindLinks.xla. Works great -- you can find it on the web.

[lotusman]

Shall try that, JLG. I have a lot of formulas there but the start of each ought to be an indication of an external source. Thanks.
Lotusman

[lotusman]

Did that, Pete, looks like all the rages are 'indoors', in the file itself, but thanks.

[lotusman]

Hmm, that looks promising. Shall give it a go.