Excel 2016 - Formulae or link sheet are automatically removed

Ashutosh_Vashisht17 

Here is a quick macro where you can delete all links at once.

Sub BreakLinks()
  Dim arrLinks As Variant, i As Integer
  
  arrLinks = ActiveWorkbook.LinkSources(xlLinkTypeExcelLinks)
  If Not IsEmpty(arrLinks) Then
    For i = 1 To UBound(arrLinks)
      ActiveWorkbook.BreakLink _
        Name:=arrLinks(i), _
        Type:=xlLinkTypeExcelLinks
    Next
  End If
  
End Sub

 Hope I could help you with this information.

Nikolino

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.