Hyperlinks in Excel misdirect when you click on them

[Ironblood]

I have a column of hyperlinks. When you select a cell with a hyperlink, copy it, paste it into the browser - it takes you to the correct place (a unique page). But if you mouse click on the link in Excel, it opens the browser window but takes me to a generic part of the website. Any ideas on why this is happening and if I can correct it?

I'm using the formula: =HYPERLINK([@CatLink1])

 

[Saga Lout]

All the links I simply type into Excel cells without using an Excel formula, work properly without using an Excel formula and go straight to the relevant sub-site.

Are you creating the formula from a pasted link out of your browser?