broken links

Daniel_Boro 

Here is a macro to quickly clear all ghost links.

Sub Test()
  Dim WS As Worksheet
  Dim F As Object 'FormatCondition
 
  For Each WS In Worksheets
    For Each F In WS.UsedRange.FormatConditions
      If F.Type = xlExpression Then
        If InStr(1, F.Formula1, "#REF!", vbTextCompare) > 0 Then
          F.Parent.FormatConditions.Delete
        End If
      End If
    Next
  Next
End Sub

VBA Code Link:  https://answers.microsoft.com/de-de/msoffice/forum/msoffice_excel-mso_other-mso_2010/geister-verkn%C3%BCpfung-nicht-l%C3%B6schbar/9b8bc6f0-3be6-4ca6-9a02-2cb0f3980417?page=2

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here