We have been facing an issue with some of out excel files which contain formulaes / linked sheets would automatically have these linking / formulaes removed randomly. This is happening with random users and random files.
Currently using : Excel 2016 standard 32 bit.
OS : Windows 10 20 H2 - 64 bit.
We have standard repair / uninstall / reinstall / latest patch updates. The only thing which seems to be persistent is that usually all these file shave .xls or .xlsm attachments.
Here is a quick macro where you can delete all links at once.
Dim arrLinks As Variant, i As Integer
arrLinks = ActiveWorkbook.LinkSources(xlLinkTypeExcelLinks)
If Not IsEmpty(arrLinks) Then
For i = 1 To UBound(arrLinks)
Hope I could help you with this information.
I know that I don't know (Socrates)
* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.