Forum Discussion
How to delete Link to removed documents
Dear everyone,
I have a problem: in the Excelsheet I need to work in, there are three links to documents that have been removed or deleted. How can I delete these links?
When I follow the normal description it doesn't work: I do pres on delete link but nothing happends. I guess because the linked document is gone.
This is the dutch article I used: https://support.microsoft.com/nl-nl/office/een-koppeling-verbreken-met-een-externe-verwijzing-in-excel-f1ca8b08-4f24-4af6-92e5-f4fdb1442748
I hope sincerely that someone can help me.
Love,
Gongon
2 Replies
- If you want to search for and remove hyperlinks in the specific area / cells, have a look at this entry .. is For Excel 2013,2016
https://www.ablebits.com/office-addins-blog/2013/09/20/remove-hyperlinks-from-excel/#remove-multiple-hyperlinks
Most of them are hidden hyperlinks in the conditional formatting of the cells. To delete them, follow the steps below.
Go to the Home tab –> Conditional Formatting –> Manage Rules –> Delete rules in the entire sheet –> OK. I'd recommend to use FindLink https://manville.org.uk/software/findlink.htm
