Removing Links in Excel

[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.

 

[RADO]

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

 

[Tom Ogilvy]

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.

 

[Tom Ogilvy]

1) was introduced in xl2002, not in earlier versions.

2) see 1)