Forum Discussion
Gubby_50
Dec 31, 2022Copper Contributor
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...
- Dec 31, 2022
Select File > Info.
Click on 'Edit Links to Files' under 'Related Documents'.
Hopefully you can select a link there, then click 'Break Link'.
Patrick2788
Dec 31, 2022Silver Contributor
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.