SOLVED
Home

update links to other workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-842467%22%20slang%3D%22en-US%22%3Eupdate%20links%20to%20other%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842467%22%20slang%3D%22en-US%22%3E%3CP%3ECan%20someone%20please%20help%20me%20to%20disable%20this%20permanently%20as%20I%20get%20frustrated%20with%20when%20making%20entries%20in%20a%20workbook%20it%20suddenly%20stops%20and%20on%20pressing%20enter%20it%20maximises%20another%20workbook%20which%20I%20then%20have%20to%20minimise%20it%20to%20continue%2C%20I%20have%20unchecked%20the%20box%20in%20advance%20options%20but%20whatever%20action%20I%20take%20afterwards%20ie%20close%20windows%20even%20a%20computer%20restart%20it%20still%20re%20checks%20the%20box.%20another%20irritating%20feature%20of%20Excel%26nbsp%3B%3C%2FP%3E%3CP%3EMTIA%3C%2FP%3E%3CP%3EDerek%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-842467%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842580%22%20slang%3D%22en-US%22%3ERe%3A%20update%20links%20to%20other%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842580%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174732%22%20target%3D%22_blank%22%3E%40Derek%20Dawson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ehi%3C%2FP%3E%3CP%3EYou%20can%20edit%20or%20break%20or%20update%20the%20links%20source%20in%20your%20Excel%20file%20as%20follows%3A%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3COL%3E%3CLI%3EClick%20on%20the%20%3CSTRONG%3EData%20Tab%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3EClick%20on%3CSTRONG%3EEdit%20Links%3C%2FSTRONG%3E%3C%2FLI%3E%3CLI%3ESelect%20the%20link%20from%20the%20box%20then%3C%2FLI%3E%3CLI%3ESelect%20the%20Option%20you%20need%20from%20the%20right%20side%20button.%20You%20Can%20select%20to%20break%20the%20links%3C%2FLI%3E%3CLI%3ETo%20specify%20what%20to%20do%20at%20Startup%20%26gt%3B%26gt%3B%20click%20on%20%22%3CSTRONG%3EStartup%20Prompt...%3C%2FSTRONG%3E%22%20in%20the%20lower%20left%20corner.%20The%20Startup%20prompt%20dialog%20box%20opens%3A%3C%2FLI%3E%3CLI%3ESelect%20%22%3CSTRONG%3EDon't%20display%20the%20alert%20and%20don't%20update%20automatic%20links%3C%2FSTRONG%3E.%22%3C%2FLI%3E%3CLI%3EHit%20Ok%20then%20Close%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842584%22%20slang%3D%22en-US%22%3ERe%3A%20update%20links%20to%20other%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842584%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174732%22%20target%3D%22_blank%22%3E%40Derek%20Dawson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20it%20is%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20685px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F130602iF2C345A7118230BD%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Break%20Links.png%22%20title%3D%22Break%20Links.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842688%22%20slang%3D%22en-US%22%3ERe%3A%20update%20links%20to%20other%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842688%22%20slang%3D%22en-US%22%3EThank%20you%20for%20your%20help%20much%20appreciated%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842708%22%20slang%3D%22en-US%22%3ERe%3A%20update%20links%20to%20other%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842708%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Nabil%3C%2FP%3E%3CP%3EFurther%20to%20this%20query%2C%20something%20is%20still%26nbsp%3B%20not%20right%2C%20when%20I%20go%20into%20Data%20the%20edit%20links%20is%20not%20available%20ie%20not%20highlighted%20I%20had%20originally%20thought%20this%20was%20because%20it%20was%20not%20linked%20to%20another%20workbook%20but%20have%20now%20found%20it%20still%20links%20to%20another%20workbook.%20I%20have%20checked%20the%20other%20workbooks%20and%20the%20edit%20links%20is%20not%20available%20in%20any%20of%20them.%20Forgot%20to%20mention%20I%20am%20using%20Office%202016%20in%20case%20it%20makes%20any%20difference.%3C%2FP%3E%3CP%3EThanks%20for%20your%20time%3C%2FP%3E%3CP%3EDerek%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-842838%22%20slang%3D%22en-US%22%3ERe%3A%20update%20links%20to%20other%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-842838%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174732%22%20target%3D%22_blank%22%3E%40Derek%20Dawson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ELinks%20could%20be%20not%20only%20in%20formulas%20within%20cells%2C%20in%20any%20other%20objects%20as%20well%20-%20conditional%20formatting%20formulas%2C%20defined%20names%2C%20etc.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20may%20try%20to%20play%20with%20Inquire%20if%20it%20exists%20in%20your%20version%20of%20Excel.%20Another%20option%20is%20FindLink%26nbsp%3B%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%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-843318%22%20slang%3D%22en-US%22%3ERe%3A%20update%20links%20to%20other%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-843318%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F174732%22%20target%3D%22_blank%22%3E%40Derek%20Dawson%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%20Derek%3C%2FP%3E%3CP%3EI%20agree%20with%20my%20friend%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3B%20that%20it's%20sometimes%20difficult%20to%20locate%20all%20kind%20of%20links%20using%20manual%20techniques%20that's%20why%20using%20the%20Inquire%20Tab%20of%20the%20ribbon%20can%20do%20that%20for%20you%20when%20analyzing%20the%20workbook.%3C%2FP%3E%3CP%3EHere%20is%20a%20video%20tutorial%20I%20created%20over%20a%20year%20ago%20about%20the%20inquire%20tab%20should%20you%20wish%20to%20refer%20to%20it.%20By%20the%20way%20it's%20available%20in%20your%20version%202016.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DyOHJJcXtQq4%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DyOHJJcXtQq4%3C%2FA%3E%3C%2FP%3E%3CP%3EHope%20that%20helps%3C%2FP%3E%3CP%3ENabil%20Mourad%3C%2FP%3E%3C%2FLINGO-BODY%3E
Derek Dawson
Occasional Contributor

Can someone please help me to disable this permanently as I get frustrated with when making entries in a workbook it suddenly stops and on pressing enter it maximises another workbook which I then have to minimise it to continue, I have unchecked the box in advance options but whatever action I take afterwards ie close windows even a computer restart it still re checks the box. another irritating feature of Excel 

MTIA

Derek

 

6 Replies

@Derek Dawson 

hi

You can edit or break or update the links source in your Excel file as follows:

 
 
 
  1. Click on the Data Tab
  2. Click on Edit Links
  3. Select the link from the box then
  4. Select the Option you need from the right side button. You Can select to break the links
  5. To specify what to do at Startup >> click on "Startup Prompt..." in the lower left corner. The Startup prompt dialog box opens:
  6. Select "Don't display the alert and don't update automatic links."
  7. Hit Ok then Close

 

Hope that helps

Nabil Mourad

Solution

@Derek Dawson 

Here it is

Break Links.png

 

Nabil Mourad

Thank you for your help much appreciated

Hi Nabil

Further to this query, something is still  not right, when I go into Data the edit links is not available ie not highlighted I had originally thought this was because it was not linked to another workbook but have now found it still links to another workbook. I have checked the other workbooks and the edit links is not available in any of them. Forgot to mention I am using Office 2016 in case it makes any difference.

Thanks for your time

Derek

 

 

 

 

@Derek Dawson 

Links could be not only in formulas within cells, in any other objects as well - conditional formatting formulas, defined names, etc.

 

You may try to play with Inquire if it exists in your version of Excel. Another option is FindLink http://www.manville.org.uk/software/findlink.htm

@Derek Dawson 

Hi Derek

I agree with my friend @Sergei Baklan  that it's sometimes difficult to locate all kind of links using manual techniques that's why using the Inquire Tab of the ribbon can do that for you when analyzing the workbook.

Here is a video tutorial I created over a year ago about the inquire tab should you wish to refer to it. By the way it's available in your version 2016.

https://www.youtube.com/watch?v=yOHJJcXtQq4

Hope that helps

Nabil Mourad

Starting from Excel 2013 we have a new feature known as Inquire. With Inquire you can analyze, audit and review your workbooks along with data dependencies and potential errors and security concerns. Let's learn about this exciting new feature.
Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
PacketMon Components are not loading in WAC 1909
HotCakeX in Windows Admin Center on
2 Replies