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