Excel Links are broken/cant be located

[TheWebJockeys]

When opening an older excel document, I first get a message to update the excel.

But it fails and gives me the following messages.

I then logged into OneDrive where the file is saved and it gives me a few more options. (as shown below in the snap shots)

What will happen if I select break links?

Will the formulas still work? 

[#2 · Accepted solution]

I advise not to click Break links. It will turn any formula that contains the link into a hard-coded value! Instead, open the file in desktop Excel and us e a tool like FINDLINK to work out where your link is used exactly: https://manville.org.uk/software/findlink.htm

[#3]

@Jan Karel Pieterse 

Sorry about the late and long reply.

Thank you very much for this one...
It has helped me to find and replace those links.

Thank you very much!