Breaking Numereous Links

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

I copy the data from a sheet I did not create, and apparently it has numerous
links in it. I have to individually Edit-Links-Break Links many, many times.
Is there a way I can do something that will break all the links in one shot ?
( I do not want to paste-values to not get the links).

Thanks,

Steve
 
Go to Edit - Links. You can now change the source, or break links from this
dialogue.
 
I guess I wasn't very clear, but that's what I am doing. When I break the
link from that dialog box, the link doesn't go away. I have to continue
breaking the links, and eventually, maybe after doing that 30 times , the
link will disappear/be removed.
 
Sub BreakLinks()'Bob Umlas
LNames = ActiveWorkbook.LinkSources(xlExcelLinks)
For i = 1 To UBound(LNames)
ActiveWorkbook.BreakLink Name:= _
LNames(i), Type:=xlLinkTypeExcelLinks
Next
End Sub
 
Thanks,

I'll give it a try. I'm very familiar with macros, but mainly via recording
them. I can't write them from scratch, and that's what the suggestion looked
like.

Thanks again,

Steve
 
I copy the data from a sheet I did not create, and apparently it has numerous
links in it. I have to individually Edit-Links-Break Links many, many times.
Is there a way I can do something that will break all the links in one shot ?
( I do not want to paste-values to not get the links).

Thanks,

Steve
Click to expand...

There is a function to break ext. links in the free ASAP-Addin:
www.asap-utilities.com.
Hope that helps.
Cheers Michael
 
Back
Top