Systematic elimination is the only solution! Follow below mentioned steps if you could not get rid of External Links! Thank you in advance for any input you would like to provide My problem is that I am unable to let go of a problem until I find a proper solution! (Which I can do, as this workbook only contains values and minimal formatting)

I have spent more time trying to figure this out than it would have taken to simply cut/paste values into a new spreadsheet. I have tried finding objects via a macro that was posted years ago, it errors and must not be good for Excel 2010.

I have tried the microsoft DeleteLink add-in - it doesn't seem to work in 2010. I have searched for part of the linked filename in the workbook with no results found. I have searched for '' in the workbook, with no results found. When I click Break Link, I get a response that this convert to values, and when I click Break Links in that popup, the popup goes away without complaint, yet the link remains. There remains a link to the second file, with Status = Unknown, which I cannot get rid of !!!! I was able to delete all of the named ranges which cleared up one of the links in the edit links dialog. The edit links dialog was referencing 2 different files. At the time I copied the data (either by doing the move/copy worksheet or cut/paste) I was not aware of links and how hard they would be to deal with after the fact! I am working in a workbook that contains 10 worksheets with varying in row count from 100 to 1000.Ī number of them were copied from a couple of other workbooks. I have tried all of the suggestions in them anyway, and have only partially resolved my issue. I've gone through all of the previous posts regarding removing bad links, but the previous posts are pretty stale, and most of the links in them are no longer working, or refer to code/add-ins that no longer work in Excel 2010, so I hope you don't mind my restarting this topic in a new thread

How to disable links in excel 2010