Hi there!

I struggle with this problem:
I want to create a hyperlink via the hyperlink funktion that redirects the user to a different sheet/cell in the same workbook. This should be a dynamic formula depending on specific data, i tried the following:

=Hyperlink(cell("address",Sheet1!A1),"Link")



(i use a CONCATENATE formula for the cell reference)

which works quite fine on my home computer using office 2016. But doesn't work on my office computer using excel365.

I have to distinct problems:
1) The browser tries to open a new tab instead of open the sheet within the existing tab
2) the browser returns "cannot open file"

Suggestions? Or even why this problem occurs?

Best regards.

Attached Files

Hyperlink.xlsx (9.8 KB, 5 views)

Your formulae appeared here with "adresse".
I changed it to "address" and all worked.