I have a Excel workbook and somewhere in this workbook either a tab or cell links to another workbook that no longer exists.
I need to find our how to remove this link. I have tried to find it with no luck, I have clicked "Edit > Links" and broken the link but it still exists. The file this links to has been deleted but the link still exist.
The issue I have is whenever I open this workbook up and click on "Update Link" it comes to the one link in question and gives me an error message.
How do I find this cell or tab that contains the link, and/or how do I remove that link ?
Cheers
Jeff
I need to find our how to remove this link. I have tried to find it with no luck, I have clicked "Edit > Links" and broken the link but it still exists. The file this links to has been deleted but the link still exist.
The issue I have is whenever I open this workbook up and click on "Update Link" it comes to the one link in question and gives me an error message.
How do I find this cell or tab that contains the link, and/or how do I remove that link ?
Cheers
Jeff