Hyperlink via hyperlink-function to same workbook in office 365
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.
|