Cannot Locate a Link

%3CLINGO-SUB%20id%3D%22lingo-sub-1444003%22%20slang%3D%22en-US%22%3ECannot%20Locate%20a%20Link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1444003%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20rather%20large%20Excel%20Workbook%20that%20all%20of%20a%20sudden%20has%20a%20link!%20I%20have%20done%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESearched%20for%20the%20link%20(Platform.xlsm).%20Looked%20in%20Formulas%2C%20Notes%2C%20Values%20and%20Comments.%20Nowhere%20to%20be%20found%3B%3C%2FP%3E%3CP%3EDeleted%20all%20cells%20from%20every%20sheet%20(unhid%20any%20hidden%20cells)%3B%3C%2FP%3E%3CP%3ERemoved%20all%20conditional%20formatting%3B%3C%2FP%3E%3CP%3EDeleted%20all%20named%20ranges%3B%3C%2FP%3E%3CP%3EDeleted%20all%20macros%3B%3C%2FP%3E%3CP%3ELooked%20for%20any%20objects%20(none)%3B%3C%2FP%3E%3CP%3EChecked%20for%20any%20Data%20Validation%20(None)%3B%3C%2FP%3E%3CP%3ENo%20data%20series%20or%20charts%3B%3C%2FP%3E%3CP%3ENo%20Hyperlinks%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20also%20tried%20deleting%20one%20sheet%20at%20a%20time%20which%20appeared%20to%20get%20rid%20of%20the%20link%20so%20I%20assumed%20that%20sheet%20was%20the%20issue.%20After%20not%20locating%20anything%20on%20that%20sheet%20I%20determined%20that%20if%20I%20delete%20any%20one%20of%20the%20sheets%20the%20link%20goes%20away.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20do%20not%20want%20to%20have%20to%20re-build%20from%20scratch%20%3CLI-EMOJI%20id%3D%22lia_disappointed-face%22%20title%3D%22%3Adisappointed_face%3A%22%3E%3C%2FLI-EMOJI%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20other%20thoughts%20would%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1444003%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1444492%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20Locate%20a%20Link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1444492%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F690603%22%20target%3D%22_blank%22%3E%40madmancha%3C%2FA%3E%26nbsp%3Bsome%20suggestions%3A%3C%2FP%3E%3CP%3E1.%20Data%2FEdit%20Links%3A%20check%20if%20you%20see%20any%20file%20listed%20there.%20They%20are%20the%20ones%20you%20want%20to%20find%20and%20remove%3C%2FP%3E%3CP%3E2.%20Find%3A%20in%20Find%20What%20just%20enter%20.xl*%20and%20Options%20should%20include%20Search%20by%20Rows%2C%20Look%20in%20Formula%2C%20Within%20Workbook%3C%2FP%3E%3CP%3E3.%26nbsp%3BLast%20resort%3A%20For%20each%20sheet%2C%20Formula%2FShow%20formula%2C%20then%20Find%2FFind%20What%3A%20%5C%20or%20.xl%20and%20repeat%20for%20each%20sheet%20until%20you%20find%20the%20link%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1444585%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20Locate%20a%20Link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1444585%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F690603%22%20target%3D%22_blank%22%3E%40madmancha%3C%2FA%3E%26nbsp%3BTry%20the%20tool%20that%20you%20find%20here%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%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1448984%22%20slang%3D%22en-US%22%3ERe%3A%20Cannot%20Locate%20a%20Link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1448984%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675276%22%20target%3D%22_blank%22%3E%40hynguyen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20response!%20After%20all%20of%20this%20it%20still%20did%20not%20work.%20I%20began%20to%20worry%20about%20my%20so-called%20Excel%20skills.%20.%20.%20Out%20of%20frustration%20I%20saved%20a%20copy%20and%20opened%20the%20saved%20file%20and%20NO%20LINK.%20Must%20have%20been%20some%20glitch%20as%20I%20did%20not%20change%20a%20thing.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20Again!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1674191%22%20slang%3D%22de-DE%22%3ERe%3A%20Cannot%20Locate%20a%20Link%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1674191%22%20slang%3D%22de-DE%22%3EIt%20would%20be%20beneficial%20if%20you%20upload%20the%20file%20(without%20any%20sensitive%20data)%20with%20the%20problem.%20That%20way%20you%20could%20get%20on%20the%20track%20of%20the%20problem%20better%20and%20you%20will%20get%20an%20acceptable%20solution%20faster.%20Win-win%20for%20everyone.%20%3CBR%20%2F%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%20Thx%20%3CBR%20%2F%3E%20Nikolino%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

I have a rather large Excel Workbook that all of a sudden has a link! I have done the following:

 

Searched for the link (Platform.xlsm). Looked in Formulas, Notes, Values and Comments. Nowhere to be found;

Deleted all cells from every sheet (unhid any hidden cells);

Removed all conditional formatting;

Deleted all named ranges;

Deleted all macros;

Looked for any objects (none);

Checked for any Data Validation (None);

No data series or charts;

No Hyperlinks;

 

I also tried deleting one sheet at a time which appeared to get rid of the link so I assumed that sheet was the issue. After not locating anything on that sheet I determined that if I delete any one of the sheets the link goes away.

 

I do not want to have to re-build from scratch

 

Any other thoughts would be greatly appreciated.

 

4 Replies
Highlighted

@madmancha some suggestions:

1. Data/Edit Links: check if you see any file listed there. They are the ones you want to find and remove

2. Find: in Find What just enter .xl* and Options should include Search by Rows, Look in Formula, Within Workbook

3. Last resort: For each sheet, Formula/Show formula, then Find/Find What: \ or .xl and repeat for each sheet until you find the link

 

Highlighted

@madmancha Try the tool that you find here:

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

Highlighted

@hynguyen 

 

Thank you for your response! After all of this it still did not work. I began to worry about my so-called Excel skills. . . Out of frustration I saved a copy and opened the saved file and NO LINK. Must have been some glitch as I did not change a thing. 

 

Thanks Again!

Highlighted
It would be beneficial if you upload the file (without any sensitive data) with the problem. That way you could get on the track of the problem better and you will get an acceptable solution faster. Win-win for everyone.


Thx
Nikolino