Hello!

I'm trying to fix an annoying problem with the HYPERLINK command.

If I enter this in a cell (as link) it works as intended ("Varebestilling.xlsm" opens and row 646 is highlighted):

Please Login or Register  to view this content.
If I enter this the command only works, if "Varebestilling.xlsm" is already open (the links in the XLOOKUP-command are complete links but have been removed here):

Please Login or Register  to view this content.
If "Varebestilling.xlsm" is closed Excel tries to open the sheet in Chrome (it's a Sharepoint sheet) resulting in a not found-error.

How can I get around this? I have also tried with the full link without luck.

Is there a better way to achieve this - I need to highlight a specific row (given by a variable) like shown in the first link - e.g. 646:646...

Thanks,
Søren