Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 09-05-2022, 08:13 AM
MaGu MaGu is offline Hyperlink via hyperlink-function to same workbook in office 365 Windows 10 Hyperlink via hyperlink-function to same workbook in office 365 Office 2016
Novice
Hyperlink via hyperlink-function to same workbook in office 365
 
Join Date: Sep 2022
Posts: 1
MaGu is on a distinguished road
Default 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.
Attached Files
File Type: xlsx Hyperlink.xlsx (9.8 KB, 3 views)
Reply With Quote
  #2  
Old 09-05-2022, 08:56 AM
p45cal's Avatar
p45cal p45cal is offline Hyperlink via hyperlink-function to same workbook in office 365 Windows 10 Hyperlink via hyperlink-function to same workbook in office 365 Office 2019
Expert
 
Join Date: Apr 2014
Posts: 863
p45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant futurep45cal has a brilliant future
Default

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

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

Other Forums: Access Forums

All times are GMT -7. The time now is 09:43 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft