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%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
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.

 

3 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!