How to delete Link to removed documents

Copper Contributor

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-exc...

 

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...

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.