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?



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?



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?

Hi,

Missed out. Is there anyway I can break the link to another workbook for just 1 cell instead of all cells using the break link function.