Can't break links (even though it is not grayed out)

[bwaights]

Hi all,

I am working on an Excel 2013 workbook and there is a link that has appeared in my workbook, and I cannot remove it for the life of me.

There is a link to an external sheet (lets call it sheet 'B') , I believe this link came about because a college copied a number of cells from this sheet 'B' and pasted them into the master wkb (the one I am working on). I have since deleted all formulas and converted everything to values or un-linked formulas. but the link to workbook B will not disappear.
I then tried killing all formulas in the sheet (select everything copy paste as values) , still there...
Then it gets even more weird, I deleted every row and column completely as an experiment, and the link is still there.
The only think that breaks the link is deleting the entire Sheet.
So there is definitely something embedded in the sheet that is linked to this other workbook , but I have no idea what it is... I have macro button in the WKB , but not on that sheet. And WKB 'B' definitely doesn't have any buttons or pictures.

I have read some other posts : like
http://www.mrexcel.com/forum/excel-...k-contains-one-more-links-cannot-updated.html

and
http://www.mrexcel.com/forum/excel-questions/371896-excel-wont-allow-me-break-link.html

but I can't find anything in there that addresses my issue. I tried deleting every single named range for example. No joy

One other thing I should mention, other people have said that the 'break links' button is grayed out for them. Not the case for me. I can click it, it give me the warning about it being irreversible, i say 'OK' , and then nothing happens...

I also have the data model loaded with some references to sheet within the same workbook (book a) the master one. Not sure if somehow this could be causing issues also...

 

[dmt32]

Hi,
Try Bill Manville's FindLink program:
Office Automation Ltd. - The Excel MVP Page

Dave

 

[bwaights]

Thanks so much, I didn't get round to testing that program.

I tracked it down, it was actually some validation that contained a formula link to the other sheet.
apparently it can happen with charts , and macro buttons also.
https://groups.google.com/forum/?fromgroups=#!topic/microsoft.public.excel.misc/IrjUMdaFFSU

 

[katcar]

I had the same problem. (Could not break link.) I had copied some tabs from another workbook and realized that not only was there data validation that linked back to the other workbook, but also a button on the tabs that had a macro from that other workbook assigned to it.