Home

External Links

%3CLINGO-SUB%20id%3D%22lingo-sub-855386%22%20slang%3D%22en-US%22%3EExternal%20Links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-855386%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20new%20to%20this%20forum.%20I%20have%20a%20large%20excel%20workbook%20that%20I%20creating%20and%20am%20using%20on%20a%20mac.%20I%20recently%20added%20to%20the%20workbook%20and%20must%20have%20added%20an%20external%20link.%20I%20know%20I%20should%20have%20been%20more%20careful%20but%20I%20cannot%20find%20the%20link%20and%20cannot%20break%20the%20link.%20I%20have%20tried%20to%20search%20the%20for%20the%20link%20but%20to%20no%20avail.%20I%20also%20tried%20to%20break%20the%20link%20but%20it%20didn't%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20anybody%20help%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-855386%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ERequests%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-855940%22%20slang%3D%22en-US%22%3ERe%3A%20External%20Links%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-855940%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F408863%22%20target%3D%22_blank%22%3E%40Jeff01840%3C%2FA%3E%26nbsp%3BI'm%20on%20Excel%20for%20Mac%2C%20v16.28%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20wrote%20you%20tried%20breaking%20the%20links.%20Assuming%20you%20went%20through%20the%20%22Edit%20links%22%20option%20found%20in%20either%20the%20Data-ribbon%20or%20the%20Data%20drop-down%20menu.%20Strange%20that%20it%20didn't%20work.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETry%20this%20one.%20On%20Excel%2FPreferences%2FView%2C%20check%20the%20%22Formulae%22%20box.%20This%20will%20display%20the%20formula%20entered%20for%20each%20cell%2C%20instead%20of%20the%20outcome%20of%20each%20formula.%20External%20links%20will%20stand%20out%20something%20like%20%22%20'%3D%2FUsers%2FXxxx%2FDocuments%2F%5BBook2.xlsx%5DSheet1'!%24A%241%22%20%22.%20It%20will%20require%20some%20manual%20review%2C%20but%20might%20help%20you%20identify%20the%20cells%20that%20contain%20the%20external%20links.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Jeff01840
Occasional Visitor

Hi,

 

I am new to this forum. I have a large excel workbook that I creating and am using on a mac. I recently added to the workbook and must have added an external link. I know I should have been more careful but I cannot find the link and cannot break the link. I have tried to search the for the link but to no avail. I also tried to break the link but it didn't work.

 

Can anybody help?

1 Reply

@Jeff01840 I'm on Excel for Mac, v16.28

 

You wrote you tried breaking the links. Assuming you went through the "Edit links" option found in either the Data-ribbon or the Data drop-down menu. Strange that it didn't work.

 

Try this one. On Excel/Preferences/View, check the "Formulae" box. This will display the formula entered for each cell, instead of the outcome of each formula. External links will stand out something like " '=/Users/Xxxx/Documents/[Book2.xlsx]Sheet1'!$A$1" ". It will require some manual review, but might help you identify the cells that contain the external links.

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies