#1
|
|||
|
|||
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. |
#2
|
||||
|
||||
Your formulae appeared here with "adresse".
I changed it to "address" and all worked. |
Tags |
excel365, hyperlink |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Hyperlink function only fully works when referring workbook is open | batchmaster | Excel | 1 | 01-26-2018 12:27 PM |
Hyperlink to open another sheet in same workbook with filtered data | tarunbaweja | Excel Programming | 1 | 03-20-2016 06:52 AM |
Hyperlink: open the document only once, quit & reopen PP, hyperlink doesnt work anymore | quanghuynguyenhua | PowerPoint | 0 | 10-10-2015 06:17 PM |
Hyperlink Format varies, depending on whether Target file was saved or unsaved on Hyperlink Copy | RichardDavey | Word | 0 | 05-26-2015 05:26 PM |
How to add attached excel workbook with hyperlink in the same workbook | lynchbro | Excel Programming | 0 | 02-24-2015 01:29 PM |