Forum Discussion
Solved
Locate cell linked to external source
When I open my workbook, I get a message that it contains links to one or more external sources. It shouldn't. Recently had this and a couple of other worksheets open and may have inadvertently lin...
Select File > Info.
Click on 'Edit Links to Files' under 'Related Documents'.
Hopefully you can select a link there, then click 'Break Link'.
External links can hide out in a few different places:
-Formulas (You can locate via find and replace)
-Data validation list sources
-Named items
-Macro buttons assigned to macros in external workbook
Typically, if you're not able to break a link then it's usually because the external link(s) are not in formulas.
Note: it's also worth closing/re-opening the workbook if you believe you've gotten rid of the links, but 'Edit Links' is still lit up. Sometimes Excel won't update the presence of links until the workbook is re-opened.