Home

Hyperlinks not linking correctly

%3CLINGO-SUB%20id%3D%22lingo-sub-412967%22%20slang%3D%22en-US%22%3EHyperlinks%20not%20linking%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-412967%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20I%20am%20trying%20to%20create%20a%20report%20with%20hyperlinks%20to%20an%20external%20website%2C%20each%20link%20containing%20a%20generic%20address%20path%20%2B%20a%20cell%20value%2C%20i.e.%20%3CA%20href%3D%22http%3A%2F%2Fwww.123.com%2Ftest%2F(cell%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ewww.123.com%2Ftest%2F(cell%3C%2FA%3E%20value).%20I%20can%20create%20the%20link%20no%20problem%20and%20the%20first%20cell%20takes%20me%20to%20the%20correct%20location%2C%20but%20on%20generating%20the%20hyperlinks%20for%20the%20rest%20of%20the%20spreadsheet%20the%20hyperlinks%20look%20to%20be%20correct%20(i.e.%20each%20have%20the%20correct%20unique%20address)%20but%20on%20clicking%20different%20links%20they%20all%20direct%20back%20to%20the%20original%20value.%20I'm%20using%20the%20hyperlink%20function%20as%20follows%20%3DHYPERLINK(%22%3CA%20href%3D%22https%3A%2F%2Fwww.123.com%2Ftest%2F%26quot%3B%26amp%3BF2%22%20target%3D%22_blank%22%20rel%3D%22noopener%20nofollow%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.123.com%2Ftest%2F%22%26amp%3BF2%3C%2FA%3E)%20and%20a%20colleague%20has%20tried%20%3DHYPERLINK(G2%2CE2)%20where%20G2%20contains%20the%20link%20and%20E2%20the%20displayed%20name%20but%20he%20has%20the%20same%20issue%20when%20creating%20additional%20links%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-412967%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-413709%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlinks%20not%20linking%20correctly%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-413709%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F316944%22%20target%3D%22_blank%22%3E%40Simon310%3C%2FA%3E%26nbsp%3B%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3Ethat's%20unusual.%20Can%20you%20post%20a%20sample%20file%20that%20shows%20that%20behaviour%20for%20just%20a%20handful%20of%20links%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Simon310
Occasional Visitor

Hi, I am trying to create a report with hyperlinks to an external website, each link containing a generic address path + a cell value, i.e. www.123.com/test/(cell value). I can create the link no problem and the first cell takes me to the correct location, but on generating the hyperlinks for the rest of the spreadsheet the hyperlinks look to be correct (i.e. each have the correct unique address) but on clicking different links they all direct back to the original value. I'm using the hyperlink function as follows =HYPERLINK("https://www.123.com/test/"&F2) and a colleague has tried =HYPERLINK(G2,E2) where G2 contains the link and E2 the displayed name but he has the same issue when creating additional links

1 Reply

Hello @Simon310 ,

 

that's unusual. Can you post a sample file that shows that behaviour for just a handful of links?

Related Conversations