Home

Breaking Links and Name Manager

%3CLINGO-SUB%20id%3D%22lingo-sub-259702%22%20slang%3D%22en-US%22%3EBreaking%20Links%20and%20Name%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-259702%22%20slang%3D%22en-US%22%3E%3CP%3Emy%20department%20has%20a%20spreadsheet%20we%20all%20update%20for%20inventory.%20Now%20that%20we%20have%20all%20put%20in%20our%20information%20we%20now%20get%20this%20pop%20up%20that%20states%20%22we%20can't%20update%20some%20of%20the%20links%22%20every%20time%20we%20open%20the%20file.%20SO%20ANNOYING.%20I%20know%20i%20can't%20set%20it%20to%20never%20update%20or%20prompt%20but%20i%20want%20to%20RESOLVE%20the%20Issue%20not%20put%20a%20bandaid%20on%20it.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20409px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F53706i14B70BD442DBFB5A%2Fimage-dimensions%2F409x149%3Fv%3D1.0%22%20width%3D%22409%22%20height%3D%22149%22%20alt%3D%22Screenshot_2.png%22%20title%3D%22Screenshot_2.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Ewhen%20i%20open%20the%20file%3C%2FSPAN%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20390px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F53707iF47D5397FE20454D%2Fimage-dimensions%2F390x167%3Fv%3D1.0%22%20width%3D%22390%22%20height%3D%22167%22%20alt%3D%22Screenshot_3.png%22%20title%3D%22Screenshot_3.png%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3Ewhen%20i%20choose%20edit%20links%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Efollowing%20what%20I%20could%20on%20some%20forums%20I%20have%20tried%20to%20break%20the%20link%20in%20edit%20links%20but%20selecting%20Break%20link%20does%20nothing.%20I%20have%20tried%20to%20go%20through%20the%20work%20book%20and%20figure%20out%20what%20cells%20are%20using%20the%20source.%20i%20have%20even%20recreated%20the%20work%20sheet%20and%20did%20a%20copy%20and%20past%20special%20values%20%26amp%3B%20number%20formatting%20hoping%20i%20would%20loose%20the%20external%20link.%20still%20no%20luck.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethere%20was%20another%20forum%20that%20mentioned%20deleting%20the%20entry%20in%20name%20manager%20but%20i%20get%20no%20option%20to%20delete%20the%20object.%20I%20just%20want%20to%20remove%20the%20reference%20to%20the%20external%20link%20or%20find%20a%20way%20to%20narrow%20down%20what%20is%20using%20that%20external%20link%20exactly.%20also%20throughout%20the%20workbook%20the%20worksheets%20do%20have%20drop%20down%20menus%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20434px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F53739i9DEF9C0592B669C6%2Fimage-dimensions%2F434x241%3Fv%3D1.0%22%20width%3D%22434%22%20height%3D%22241%22%20alt%3D%22Screenshot_4.png%22%20title%3D%22Screenshot_4.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-259702%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBreak%20LInks%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExternal%20Links%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EName%20Manager%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-369707%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20Links%20and%20Name%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-369707%22%20slang%3D%22en-US%22%3E%3CP%3EI%20used%20findlink%20and%20it%20worked.%26nbsp%3B%20Thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359754%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20Links%20and%20Name%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359754%22%20slang%3D%22en-US%22%3EYou%20mean%20the%20FINDLINK%20tool%20did%20not%20find%20the%20link%3F%20Try%20saving%20the%20file%20after%20breaking%20the%20link%2C%20closing%20it%20and%20opening%20it%20again.%20If%20that%20fails%2C%20can%20you%20perhaps%20email%20the%20file%20to%20me%20so%20I%20can%20have%20a%20look%3F%20Find%20my%20email%20address%20on%20my%20website%2C%20bottom%20of%20each%20page.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-359688%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20Links%20and%20Name%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-359688%22%20slang%3D%22en-US%22%3E%3CP%3EI%20used%20the%20break%20link%20add-in%20recommended%20and%20whilst%20it%20did%20find%20links%2C%20and%20I%20clicked%20to%20delete%20them%2C%20I%20still%20have%20a%20source%20listed%20in%20the%20Edit%20Links%20section.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20I%20tried%20the%20Break%20Link%20button%20again%2C%20but%20still%20nothing.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20in%20advance%26nbsp%3B%3C%2FP%3E%3CP%3ELori%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320893%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20Links%20and%20Name%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320893%22%20slang%3D%22en-US%22%3E%3CP%3ETry%20using%20FindLink%20by%20Bill%20Manville%3A%20%3CA%20href%3D%22http%3A%2F%2Fwww.manville.org.uk%2Fsoftware%2Ffindlink.htm%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.manville.org.uk%2Fsoftware%2Ffindlink.htm%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-320879%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20Links%20and%20Name%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-320879%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20the%20exact%20same%20issue%20and%20can't%20find%20the%20reference.%26nbsp%3B%20I%20tried%20tabing%20from%20the%20bottom%20right%20cell%20in%20the%20table%20-%20but%20still%20no%20luck.%26nbsp%3B%20Any%20other%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-259727%22%20slang%3D%22en-US%22%3ERe%3A%20Breaking%20Links%20and%20Name%20Manager%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-259727%22%20slang%3D%22en-US%22%3EIt%20is%20quite%20likely%20there%20is%20a%20hidden%20link%20in%20one%20of%20the%20table%20columns.%20Excel%20retains%20the%20formula%20which%20has%20been%20used%20in%20a%20table%20column.%20To%20find%20the%20problem%20column%2C%20add%20a%20new%20row%20by%20selecting%20the%20bottom-right%20cell%20of%20your%20table%20and%20hitting%20the%20TAB%20key%20once.%3CBR%20%2F%3ENow%20check%20all%20formulas%20in%20the%20newly%20added%20row.%3C%2FLINGO-BODY%3E
Deleted
Not applicable

my department has a spreadsheet we all update for inventory. Now that we have all put in our information we now get this pop up that states "we can't update some of the links" every time we open the file. SO ANNOYING. I know i can't set it to never update or prompt but i want to RESOLVE the Issue not put a bandaid on it.

Screenshot_2.pngwhen i open the fileScreenshot_3.pngwhen i choose edit links

following what I could on some forums I have tried to break the link in edit links but selecting Break link does nothing. I have tried to go through the work book and figure out what cells are using the source. i have even recreated the work sheet and did a copy and past special values & number formatting hoping i would loose the external link. still no luck. 

 

there was another forum that mentioned deleting the entry in name manager but i get no option to delete the object. I just want to remove the reference to the external link or find a way to narrow down what is using that external link exactly. also throughout the workbook the worksheets do have drop down menus

Screenshot_4.png

 

 

6 Replies
It is quite likely there is a hidden link in one of the table columns. Excel retains the formula which has been used in a table column. To find the problem column, add a new row by selecting the bottom-right cell of your table and hitting the TAB key once.
Now check all formulas in the newly added row.

I am having the exact same issue and can't find the reference.  I tried tabing from the bottom right cell in the table - but still no luck.  Any other suggestions?

Try using FindLink by Bill Manville: http://www.manville.org.uk/software/findlink.htm

I used the break link add-in recommended and whilst it did find links, and I clicked to delete them, I still have a source listed in the Edit Links section.

 

So I tried the Break Link button again, but still nothing.

 

Thank in advance 

Lori

 

You mean the FINDLINK tool did not find the link? Try saving the file after breaking the link, closing it and opening it again. If that fails, can you perhaps email the file to me so I can have a look? Find my email address on my website, bottom of each page.

I used findlink and it worked.  Thank you.