I had a link I could not delete and discovered after going to file/Check for Issues/Check Compatibility that I had somehow copied over conditional formatting that was linked to another file. Unfortunately, I had copied this offending worksheet 25 times within my file so I had to select all in each tab, go to Conditional Formatting/Manage Rules and delete rules through every tab. Then I went to Data/Edit Links and I was able to break the link and resolve the problem.


On Monday, April 12, 2010 5:45:01 AM UTC-7, 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?