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'.
Thank you. This led me to find the links and use a simple "Find and replace" to correct all the links.
The external links were to a worksheet in a back-up copy. Simply had to replace the name of that backup copy with a blank to change the link to the same worksheet in my workbook.
The external links were to a worksheet in a back-up copy. Simply had to replace the name of that backup copy with a blank to change the link to the same worksheet in my workbook.