Internal/External Links

[eggyjla]

I have a spreadsheet that contains external links to other workbooks. Using the [Edit][Links] I'm able to identify the link, however I am unable to locate that link within the workbook. What is/are the preferred methods for locating links within a workbook.
It might be nice if the Links window would state the cell that contains the link.

 

[jncunliffe]

I don't think there's a nice way to achieve this. Things to try would be to turn on the formula view in Options:View. This should help the links stand out. Alternatively try using Find on the link's name.

Jon C

 

[eggyjla]

I've tried to search each worksheet looking for the source of the link and have not been successful. Any other ideas where the link might be referenced. I have also tried to Break Links, but the link still exists afterward.