erroneous external links warning

%3CLINGO-SUB%20id%3D%22lingo-sub-1526313%22%20slang%3D%22en-US%22%3Eerroneous%20external%20links%20warning%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526313%22%20slang%3D%22en-US%22%3E%3CP%3EEvery%20time%20I%20open%20a%20certain%20Excel%20workbook%2C%20I%20get%20a%20warning%20that%20the%20file%20contains%20external%20links.%20It%20doesn't.%20I%20have%20followed%20all%20the%20advice%20and%20searched%20the%20entire%20workbook%2C%20sheet%20by%20sheet%20and%20cell%20by%20cell%2C%20for%20anything%20containing%20a%20link%2C%20and%20it%20just%20doesn't%20have%20any%20links.%20This%20is%20a%20complicated%20(for%20me)%20workbook%20with%20a%20lot%20of%20formulas%20and%20data%2C%20and%20I%20don't%20want%20to%20spend%20the%20time%20it%20would%20take%20to%20recreate%20it%20from%20scratch%20just%20to%20make%20the%20dumb%20error%20message%20go%20away.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHow%20do%20I%20find%20what's%20causing%20this%20error%3F%20Or%20at%20least%20make%20this%20irritating%20warning%20stop%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1526313%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20on%20Mac%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1526354%22%20slang%3D%22en-US%22%3ERe%3A%20erroneous%20external%20links%20warning%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1526354%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730611%22%20target%3D%22_blank%22%3E%40loripax%3C%2FA%3E%26nbsp%3B%20I%20had%20a%20similar%20problem%20and%20another%20person%20here%20recommended%20this%20tool%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fmanville.org.uk%2Fsoftware%2Ffindlink.htm%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fmanville.org.uk%2Fsoftware%2Ffindlink.htm%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20worked%20awesome%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527186%22%20slang%3D%22en-US%22%3ERe%3A%20erroneous%20external%20links%20warning%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527186%22%20slang%3D%22en-US%22%3EWithout%20the%20workbook%20I%20can%20only%20guess.%20Most%20of%20these%20links%20come%20from%20the%20conditional%20formatting%20of%20copied%20sheets.%20You%20can%20do%20that%20under%20Conditional%20Formatting%20-%26gt%3B%20Clear%20Rule%20-%26gt%3B%20Clear%20Rules%20in%20Entire%20Sheet%20...%20as%20I%20said%20is%20only%20a%20guess.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20would%20be%20happy%20to%20find%20out%20if%20I%20could%20help.%3CBR%20%2F%3E%3CBR%20%2F%3ENikolino%3CBR%20%2F%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Every time I open a certain Excel workbook, I get a warning that the file contains external links. It doesn't. I have followed all the advice and searched the entire workbook, sheet by sheet and cell by cell, for anything containing a link, and it just doesn't have any links. This is a complicated (for me) workbook with a lot of formulas and data, and I don't want to spend the time it would take to recreate it from scratch just to make the dumb error message go away. 

 

How do I find what's causing this error? Or at least make this irritating warning stop?

2 Replies
Highlighted

@loripax  I had a similar problem and another person here recommended this tool:

https://manville.org.uk/software/findlink.htm 

It worked awesome

Highlighted
Without the workbook I can only guess. Most of these links come from the conditional formatting of copied sheets. You can do that under Conditional Formatting -> Clear Rule -> Clear Rules in Entire Sheet ... as I said is only a guess.

I would be happy to find out if I could help.

Nikolino
I know I don't know anything (Socrates)