Removing Links in Excel

  • Thread starter Thread starter Mac
  • Start date Start date
M

Mac

Is there a global way to remove all links at one time in a
workbook or do I have to manually select each linked cell
and remove the link individually? Any shortcut toward the
removal of links would be very helpful. Thank you.
 
Two ways: manually and programmatically

1) Manually: go to menu Edit/Links. It will show you all links in your
workbook in one list. Select then and click Break Link

2) In Visual Basic: run this code

Sub RemoveLinks()
Dim Links As Variant
Dim i As Integer

Links = ActiveWorkbook.LinkSources(xlExcelLinks)

If Not IsEmpty(Links) Then
For i = LBound(Links) To UBound(Links)
ActiveWorkbook.BreakLink Links(i), xlLinkTypeExcelLinks
Next i
End If
End Sub

Best -
RADO
 
If the current workbook has the same pages and so forth as the workbook you
are linked to and you are trying to just break the link, go into
Edit=>Links, select the link and do Change source, then select the current
workbook as the source.
 
Back
Top