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'.
Select File > Info.
Click on 'Edit Links to Files' under 'Related Documents'.
Hopefully you can select a link there, then click 'Break Link'.
HansVogelaar how to find the destination cells that are linking to the external source?
Press Ctrl+F to activate the Find dialog.
Enter [ in the 'Find what' box.
If you don't see the extra search options, click 'Options >>'.
Make sure that Workbook is selected in the Within drop down, and Formulas is selected in the 'Look in' drop down.
Also make sure that the 'Match entire cell contents' check box is clear (not ticked).
Click Next, or 'Find All'.