I inherited a spreadsheet that had these darn things. Even though I tried to "unlink" them, nothing would happen. A simple solution that worked for me like a champ was to do the following:
Change your spreadsheet to a straight "xlx" via "save as", read it back in, and write it back out via "save as" again to a "xlsx". Yes, you get a stern warning about "EVERYTHING YOU ARE GOING TO LOSE, but if you have a fairly straight spreadsheet, it should work fine for you. At least it did for me. - Mark

On Monday, April 12, 2010 8:45:01 AM UTC-4, swoxo wrote:
In Excel 2007, I have a workbook with one link that I want to break. In the
Ribbon, I go to the Data tab, and in the Connections section I choose Edit
Links. In the Edit Links window, I select the link that I want to break
(there is only one link there), and I click on the button that says "Break
Link". I get a pop-up warning that once I break the link, my action cannot
be undone. There are two buttons under the warning, one that says "Break
Links" and one that says "Cancel". I click on "Break Links" and nothing
happens. My link is still there, and if I save and close the workbook, I
still get the security alert every time I reopen it.

I cannot delete or relocate the source Excel workbook that mine is linked
to, because other people are using that source. I just want to break my
workbook's link to that source. Any ideas why the Break Link button isn't
doing that for me?