break links not working

L

lemensk

I believe I tracked down my Problem: I copied a worksheet from another workbook and I made it Hidden. Then I started having the annoying message pop up. I couldn't find anything wrong in the name manager, and yet there was a link with Status Unknown that I couldn't break.

Unhide the sheet I copied, and BLAM! I have a WHOLE BUNCH of names that refer to external files. I am still confused why you cannot see all the namesin name manager (hidden and not hidden)
 
G

GS

I believe I tracked down my Problem: I copied a worksheet from
another workbook and I made it Hidden. Then I started having the
annoying message pop up. I couldn't find anything wrong in the name
manager, and yet there was a link with Status Unknown that I couldn't
break.

Unhide the sheet I copied, and BLAM! I have a WHOLE BUNCH of names
that refer to external files. I am still confused why you cannot see
all the names in name manager (hidden and not hidden)

Names that are hidden do not appear in Excel's built-in NameManager or
the NameBox dropdown. They do appear in JKP's NameManager addin!

The links are likely due to those names on the imported sheet having
global scope in the workbook they were defined in. IMO, this is another
fine example of why global scope naming should NEVER be used unless
absolutely necessary!

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
K

kameshsubramanian

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?



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 All,

The issue relates to linking of cells to another workbook. When i click on Data-Break Link all the links get broken instead of just 1 link.
 
K

kameshsubramanian

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?



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?



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.
 
G

GS

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.

Did you try to manually edit the formula in that cell to remove the
link?

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion
 
1

1978mmeame

There's a lot of good ideas in here on how to find external links. I've gone through all of them and still have a link somewhere. You'd think that Excel would let you know where the links are if you check a box or something.. After all, you can do it with Compatibility checker, why not with Edit links?
How hard could it be Microsoft?

My 2 cents.

When trying to find a link that might be in a formula you can use the Ctrl+F to Find and type in the name of the linked file you found in Edit links on the Data tab. In the dropdown you have a choice of looking within a sheet or a workbook. You should get a listing of cells when you click Find All..

If you have a lot of links you want to eliminate, you can short cut it by looking for "[". All external links contain the square bracket at the beginning of the file's location. You can also do a mass correction if you wantby clicking on the Replace tab.

If you still have the issue, check Conditional Formatting. The problem maymanifest itself in the formula you're using, or in the Rule on the leftmost column (that's where my link was hiding). Very irritating to find them there because the only way to break that link is to remove the conditional formatting and then re-make them if you really need it, which you would or you wouldn't have built them in the first place.

Personally, I don't use Names in my spreadsheets. If you do, check them out. It's a good place to hide links.
 
M

mrjamieedwards

Terry Morrison you are a genuis! Well not sure actually but you helped me find my problem of links I couldn't break which was related to dropdown boxes. Thank you!

Jamie
 
B

bram.perlat

Using Data menu, use the option "Circle invalid data" (under the Data Validation button), I finally found what the problem was. Thank you!!

Op woensdag 3 oktober 2012 17:00:13 UTC+2 schreef (e-mail address removed):
 
P

poonmasterkunn

First time using this Google groups, can't believe this problem is this old. I have a spreadsheet that references a named range on another spreadsheet. I use the data validation to save entries to one page. Once completed, I copy/move the ss I made my entries in and save as a new file. Each time the spreadsheet is opened it prompts to update, was never able to get break links to work (Excel 2010). Tried the Clear All for Data Validation, Ctrl+F3 to delete names, etc, but was never able to break the link. Every time I opened the file I got the update prompt. Until I saved the file as Excel 97- 2003, now when I open the file, no prompt to update the link I could never break. Thank you MS for leaving this problem in existence for so long.

THANK YOU (e-mail address removed)!!! I have been working on this for HOURS and noneof the posted methods would delete my broken links. Saving as an Excel 97-2003 worked! I then resaved back into .xlsx form, issue was fixed.
 
D

davidxmichaud

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, Ihave a workbook with one link that I want to break. In the Ribbon, I go tothe 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 onelink 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. Ijust want to break my workbook's link to that source. Any ideas why the Break Link button isn't doing that for me?
 
H

hrcsynqor

You may please try the following:



Undder the formula bar, click name manager and delete the names and then give try.

I hope it will work.

Seeing an external reference here is what helped me find my issue.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top