Home

Hyperlinks that are unstable.

%3CLINGO-SUB%20id%3D%22lingo-sub-823920%22%20slang%3D%22en-US%22%3EHyperlinks%20that%20are%20unstable.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-823920%22%20slang%3D%22en-US%22%3E%3CP%3E%26nbsp%3B5%20year%20old%20problem.%26nbsp%3B%20I%26nbsp%3B%26nbsp%3B%20use%20the%20default%20Window%2010%20mapping%20to%20link%20videos%20on%20Drive%20G%20to%20Excel%20Spreadsheets%20on%20Drive%20G.%26nbsp%3B%26nbsp%3B%20They%20last%20about%203%20weeks%20.%26nbsp%3B%20After%20that%20I%20get%20the%20message%20%22site%20not%20valid%22%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EProblem%20has%20stumped%20half%20a%20dozen%20tech%20agents.%26nbsp%3B%20Now%20at%20level%203%20with%20India%20and%20best%26nbsp%3B%20agent%20can%20do%20is%20watch%20a%26nbsp%3B%20sample%20link%20on%20a%20weekly%20basis.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnly%20fix%20I%26nbsp%3B%20have%20found%20is%20to%20remap%20the%20path%20.%26nbsp%3B%26nbsp%3B%20Likely%20100%20or%20more%20links%20monthly.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOnly%20thing%20I%20can%20figure%20is%20that%20McAfee%2C%20Windows%20Defender%20or%20System%20Mechanic%20are%20corrupting%20the%20path.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-823920%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-824737%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20that%20are%20unstable.%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-824737%22%20slang%3D%22en-US%22%3ECan%20you%20perhaps%20upload%20a%20file%20which%20shows%20the%20issue%3F%20It%20does%20not%20need%20more%20than%20a%20couple%20of%20those%20links.%20One%20solution%20might%20be%20to%20place%20the%20hyperlinks%20into%20cells%20as%20plain%20text%20and%20then%20use%20the%20HYPERLINK%20worksheet%20function%20to%20dynamically%20generate%20a%20hyperlink%20from%20that%20cell's%20content.%3C%2FLINGO-BODY%3E
Mcenduro
New Contributor

 5 year old problem.  I   use the default Window 10 mapping to link videos on Drive G to Excel Spreadsheets on Drive G.   They last about 3 weeks .  After that I get the message "site not valid"

 

Problem has stumped half a dozen tech agents.  Now at level 3 with India and best  agent can do is watch a  sample link on a weekly basis. 

 

Only fix I  have found is to remap the path .   Likely 100 or more links monthly. 

 

Only thing I can figure is that McAfee, Windows Defender or System Mechanic are corrupting the path. 

1 Reply
Can you perhaps upload a file which shows the issue? It does not need more than a couple of those links. One solution might be to place the hyperlinks into cells as plain text and then use the HYPERLINK worksheet function to dynamically generate a hyperlink from that cell's content.