why can't break links?

  • Thread starter Thread starter Ian Elliott
  • Start date Start date
I

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
 
Back
Top