Removing Links
 

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

Removing Links
 

Try looking in the defined names collection.


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

Removing Links
 

Do you mean DataEdit Links does not work?

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

Perhaps the links are in defined names?

FormulasName Manager..............anything in there?


Gord Dibben MS Excel MVP

On Wed, 4 Nov 2009 11:04:02 -0800, Curtis
wrote:

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

Removing Links
 

Use this code to break all links:

Sub UseBreakLink()
Dim astrLinks As Variant
astrLinks = ActiveWorkbook.LinkSources(Type:=xlLinkTypeExcelLi nks)
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--

--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Gord Dibben" wrote:

Do you mean DataEdit Links does not work?

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

Perhaps the links are in defined names?

FormulasName Manager..............anything in there?


Gord Dibben MS Excel MVP

On Wed, 4 Nov 2009 11:04:02 -0800, Curtis
wrote:

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

.