Removing Links in Excel

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

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
 
T

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