Removing Links

[Curtis]

I have old links in a document that no longer exist however the file still
looks for them...... How can I deleted them.

Note: Data, Edit Connections, delete does not work

I use Excel 2007

Thanks

 

[Bob Umlas]

Try looking in the defined names collection.

 

[Gord Dibben]

Do you mean Data>Edit Links does not work?

Do you see the links in the dialog but cannot "break links"?

Perhaps the links are in defined names?

Formulas>Name Manager..............anything in there?


Gord Dibben MS Excel MVP

 

[ryguy7272]

Use this code to break all links:

Sub UseBreakLink()
Dim astrLinks As Variant
astrLinks = ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLinks)
For i = 1 To UBound(astrLinks)
ActiveWorkbook.BreakLink _
Name:=astrLinks(i), _
Type:=xlLinkTypeExcelLinks
Next i
End Sub

http://www.anthony-vba.kefra.com/vba/vbabasic1.htm
http://www.rondebruin.nl/code.htm


HTH,
Ryan--