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
Highlighted
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
Highlighted

@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
Links in Planner Task Notes are active!
Robin Nilsson in Planner on
0 Replies
Copying Links to Paragraphs in OneNote
kayla7 in Office 365 on
1 Replies
Form link won't open on iPhone
kjmaior in Microsoft Forms on
0 Replies