cannot break links or change source

[Thirsa]

Hi Folks,

I seem to have a very crazy bug in one of my spreadsheets (attached). When I open it, it tells me it contains links which cannot be updated and indeed when I click 'edit links' it shows a spreadsheet name which no longer exists. Usually, I solve such a problem by clicking either 'change source' or 'break link', but when I try those options in this spreadsheet, nothing happens.
The link remains as it is.

Next, I've tried to search for the actual cells containing the links, but neither my formulas nor my data validation cells contain "missing links" (bad joke, I know, but I couldn't resist ).

I'm beginning to fear that the only solution for losing this non existing link is to make the spreadsheet again from scratch and I'm not really looking forward to that. So...any suggestions for an easier solution?

Hope you can help me out.
Thanks in advance
Thirsa

[Thirsa]

I just realised that one of the sheets and the VBA in the spreadsheet I attached are password protected. Don't know if it's necessary to access them in order to solve the problem, but just in case I've attached an unprotected version to this message.

[Thirsa]

One of my colleagues came up with a solution, so thanks for thinking along but the problem is solved.