So at my job I have to make a lot excel files and most of the time I just re-use some of the templates that are created by some of my colleagues. The problem with that is, there are so many links in those excels to either their home folders, or some sites which I do not have permissions to, so everytime when I open the files I get these warnings.
And if no permission, they keep throwing errors. Breaking the links as per this Microsoft article does not work either.
So I found this wonderful excel Macro which can scan through the workbook and delete all of them. It is called Findlink. Just download it, and open it when required, and you are done.
FindLink is a lifesaver!