Forum Discussion

Daniel_Boro's avatar
Daniel_Boro
Copper Contributor
Oct 26, 2020

broken links

Hi,   I broke all the links in the edit links tab, but they are still showing - see attached file   Could this slow down the file? How can it be fixed?   Thank you!     Updating Media ...
excel
NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Oct 26, 2020

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

Resources