Forum Discussion

Ashutosh_Vashisht17's avatar
Ashutosh_Vashisht17
Copper Contributor
Jun 02, 2021

Excel 2016 - Formulae or link sheet are automatically removed

Hi All , 

 

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. 

excel
Formulas and Functions

1 Reply

  • NikolinoDE's avatar
    NikolinoDE
    Gold Contributor
    Jun 02, 2021

    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. 

Resources