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.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Steve" wrote:

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

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.


"Luke M" wrote:

Go to Edit - Links. You can now change the source, or break links from this
dialogue.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Steve" wrote:

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

Sub BreakLinks()'Bob Umlas
LNames = ActiveWorkbook.LinkSources(xlExcelLinks)
For i = 1 To UBound(LNames)
ActiveWorkbook.BreakLink Name:= _
LNames(i), Type:=xlLinkTypeExcelLinks
Next
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
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

Does this go in the Visual basic modules like a macro ?

"Don Guillett" wrote:

Sub BreakLinks()'Bob Umlas
LNames = ActiveWorkbook.LinkSources(xlExcelLinks)
For i = 1 To UBound(LNames)
ActiveWorkbook.BreakLink Name:= _
LNames(i), Type:=xlLinkTypeExcelLinks
Next
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
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

Exactly like a macro.

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Steve wrote:

Does this go in the Visual basic modules like a macro ?

"Don Guillett" wrote:

Sub BreakLinks()'Bob Umlas
LNames = ActiveWorkbook.LinkSources(xlExcelLinks)
For i = 1 To UBound(LNames)
ActiveWorkbook.BreakLink Name:= _
LNames(i), Type:=xlLinkTypeExcelLinks
Next
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
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



--

Dave Peterson

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

"Dave Peterson" wrote:

Exactly like a macro.

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Steve wrote:

Does this go in the Visual basic modules like a macro ?

"Don Guillett" wrote:

Sub BreakLinks()'Bob Umlas
LNames = ActiveWorkbook.LinkSources(xlExcelLinks)
For i = 1 To UBound(LNames)
ActiveWorkbook.BreakLink Name:= _
LNames(i), Type:=xlLinkTypeExcelLinks
Next
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
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



--

Dave Peterson

On Oct 6, 3:32*pm, Steve wrote:
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

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

The next step in your education is writing macros

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
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

"Dave Peterson" wrote:

Exactly like a macro.

If you're new to macros:

Debra Dalgleish has some notes how to implement macros he
http://www.contextures.com/xlvba01.html

David McRitchie has an intro to macros:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

Ron de Bruin's intro to macros:
http://www.rondebruin.nl/code.htm

(General, Regular and Standard modules all describe the same thing.)

Steve wrote:

Does this go in the Visual basic modules like a macro ?

"Don Guillett" wrote:

Sub BreakLinks()'Bob Umlas
LNames = ActiveWorkbook.LinkSources(xlExcelLinks)
For i = 1 To UBound(LNames)
ActiveWorkbook.BreakLink Name:= _
LNames(i), Type:=xlLinkTypeExcelLinks
Next
End Sub

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
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



--

Dave Peterson