Home

External link appears to be there, but can;t be found

%3CLINGO-SUB%20id%3D%22lingo-sub-926689%22%20slang%3D%22en-US%22%3EExternal%20link%20appears%20to%20be%20there%2C%20but%20can%3Bt%20be%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926689%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20opening%20a%20file%2C%20prompt%20shows%20that%20there%20is%20an%20external%20link.%3C%2FP%3E%3CP%3EWhen%20checking%20%26gt%3B%26gt%3B%20DATA%20%26gt%3B%26gt%3B%20External%20links%20you%20can%20see%20the%20link%20to%20the%20external%20file.%3C%2FP%3E%3CP%3EBut%20when%20I%20do%20a%20search%20(CNTRL%20%2BF)%20on%20.xl%20it%20returns%20with%20a%20no%20found.%3C%2FP%3E%3CP%3EHow%20can%20I%20find%20the%20particular%20cell%20that%20has%20this%20reference%20to%20the%20external%20file%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-926689%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-926829%22%20slang%3D%22en-US%22%3ERe%3A%20External%20link%20appears%20to%20be%20there%2C%20but%20can%3Bt%20be%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926829%22%20slang%3D%22en-US%22%3EDownload%20this%20tool%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%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttp%3A%2F%2Fwww.manville.org.uk%2Fsoftware%2Ffindlink.htm%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-926830%22%20slang%3D%22en-US%22%3ERe%3A%20External%20link%20appears%20to%20be%20there%2C%20but%20can%3Bt%20be%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926830%22%20slang%3D%22en-US%22%3EHallo%20Jan%20Karel%2C%3CBR%20%2F%3E%3CBR%20%2F%3EDat%20kan%20ik%20helaas%20niet%2C%20is%20niet%20toegestaan.%3CBR%20%2F%3EI%20can't%2C%20company%20policy%20does%20not%20allow%20me%20to.%3CBR%20%2F%3E%3CBR%20%2F%3EKind%20regards%2Fgroetjes%2C%3CBR%20%2F%3E%3CBR%20%2F%3EJay%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-926872%22%20slang%3D%22en-US%22%3ERe%3A%20External%20link%20appears%20to%20be%20there%2C%20but%20can%3Bt%20be%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926872%22%20slang%3D%22en-US%22%3EThat%20is%20silly%2C%20this%20is%20the%20worlds%20best%20(and%20only)%20tool%20that%20is%20capable%20of%20finding%20where%20your%20links%20are%20hiding.%20Get%20IT%20to%20give%20you%20permission%20to%20DL%20that%20little%20tool.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-926916%22%20slang%3D%22en-US%22%3ERe%3A%20External%20link%20appears%20to%20be%20there%2C%20but%20can%3Bt%20be%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-926916%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BThat%20may%20well%20be%2C%20but%20security%20is%20pretty%20tight%20within%20the%20company.%20No%20add%20ins%20allowed.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-927058%22%20slang%3D%22en-US%22%3ERe%3A%20External%20link%20appears%20to%20be%20there%2C%20but%20can%3Bt%20be%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-927058%22%20slang%3D%22en-US%22%3EWow%2C%20I%20do%20not%20envy%20you.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-933131%22%20slang%3D%22en-US%22%3ERe%3A%20External%20link%20appears%20to%20be%20there%2C%20but%20can%3Bt%20be%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-933131%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F22322%22%20target%3D%22_blank%22%3E%40Jan%20Karel%20Pieterse%3C%2FA%3E%26nbsp%3BNor%20I%20myself%2C%20but%20this%20is%20becoming%20corporate%20standard%20within%20the%20larger%20companies%20in%20my%20part%20of%20the%20woods.....%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20mean%20time%20I%20am%20still%20stuck%20with%20my%20problem.....%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-933400%22%20slang%3D%22en-US%22%3ERe%3A%20External%20link%20appears%20to%20be%20there%2C%20but%20can%3Bt%20be%20found%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-933400%22%20slang%3D%22en-US%22%3EA%20link%20can%20be%20in%20any%20object%20which%20allows%20a%20cell%20reference.%20Thus%3A%3CBR%20%2F%3E-%20Chart%20elements%20(there%20are%20several%20chart%20items%20which%20may%20have%20a%20cell%20ref%20like%20the%20title%2C%20the%20axes%20titles%2C%20data%20labels%2C%20...)%3CBR%20%2F%3E-%20Forms%20controls%3CBR%20%2F%3E-%20ActiveX%20controls%3CBR%20%2F%3E-%20Data%20Validation%3CBR%20%2F%3E-%20Conditional%20formatting%3CBR%20%2F%3E-%20Hyperlinks%3CBR%20%2F%3E-%20Range%20names%3CBR%20%2F%3E-%20Text%20box%20and%20other%20shapes%3CBR%20%2F%3E-%20...%3CBR%20%2F%3E%3CBR%20%2F%3EBest%20of%20luck%20finding%20them%20(or%20send%20the%20file%20to%20me%2C%20I%20can%20do%20the%20automated%20look%20up%20for%20you)%3C%2FLINGO-BODY%3E
Jan-Willem Rulkens
New Contributor

When opening a file, prompt shows that there is an external link.

When checking >> DATA >> External links you can see the link to the external file.

But when I do a search (CNTRL +F) on .xl it returns with a no found.

How can I find the particular cell that has this reference to the external file?

7 Replies
Hallo Jan Karel,

Dat kan ik helaas niet, is niet toegestaan.
I can't, company policy does not allow me to.

Kind regards/groetjes,

Jay
That is silly, this is the worlds best (and only) tool that is capable of finding where your links are hiding. Get IT to give you permission to DL that little tool.

@Jan Karel Pieterse That may well be, but security is pretty tight within the company. No add ins allowed.

Wow, I do not envy you.

@Jan Karel Pieterse Nor I myself, but this is becoming corporate standard within the larger companies in my part of the woods.....

 

In the mean time I am still stuck with my problem.....

A link can be in any object which allows a cell reference. Thus:
- Chart elements (there are several chart items which may have a cell ref like the title, the axes titles, data labels, ...)
- Forms controls
- ActiveX controls
- Data Validation
- Conditional formatting
- Hyperlinks
- Range names
- Text box and other shapes
- ...

Best of luck finding them (or send the file to me, I can do the automated look up for you)
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies