Not sure about this but you may? have to UN share first.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"swoxo" wrote in message
...
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?

That is a good suggestion so I gave it a try, but it turned out that the
workbook wasn't shared, I already had exclusive use.

Thx,
swoxo

"Don Guillett" wrote:

Not sure about this but you may? have to UN share first.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"swoxo" wrote in message
...
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?

.