why can't break links?

[Ian Elliott]

I have a workbook with a macro (code at the end of this
message) where I copy sheets from another workbook into
this one.
To change the formulas in the worksheets I copied to
values, I am breaking the links through Edit>Links...
However, for some reason I cannot break a few of the
workbook links.
The ones I can break, after I highlight the file, and
click on Break Link, the file disappears.
But for the ones I can't, even though I click on the file,
and then click on Break Link, the file still stays there,
under Source, Type, Update, and Status.
Can anyone maybe tell me why? Appreciate all the help,
thanks.

Workbooks.Open FileName:="\\blah\blah.xls", UpdateLinks:=0
Worksheets("Sheet1").Copy after:=ThisWorkbook.Sheets
("Balance")
Sheets("Balance").Delete
Worksheets("Sheet1").Name = "Balance"
Workbooks("blah.xls").Close savechanges:=False

 

[Dave Peterson]

You may want to use Bill Manville's FindLink.xla to see where those links are.
Maybe it'll give you a clue what to do next.

Findlink.zip from
http://www.BMSLtd.co.uk/mvp

(the can hide in some strange spots.)