Jun 19 2020 04:32 AM - edited Jun 19 2020 04:33 AM
Hi all,
In "Sheet1"I am trying to reference a Hyperlink from another sheet "MasterSheet". But i am getting "Cannot Open Specified File" error.
If i just type the URL in the cell in "MasterSheet" and reference it in sheet 1 it works fine. Unfortunately this isn't good enough, i want to use a Hyperlink so i can have the file name that the URL is pointing to viable in "Sheet1" for example "Document A" .
From reading other treads i tried using the Hyperlink function but this didn't fix the problem either.
=HYPERLINK(MasterSheet!G22,"Test").
To make this more complicated i am using a lookup table to determine which cell to reference, but that's another days problem. I have the lookuptable part working so hopefully if i can get the hyperlink part working by itself i can throw it into the lookup formula without much fuss.
Can someone please help. My heads fit to explode with this.
Thanks in Advance
Niall
Jun 21 2020 04:45 AM
Jun 21 2020 04:54 AM
Jun 23 2020 01:18 PM
SolutionHi @niallfagan
The solution to your query work like this
=HYPERLINK("#MasterSheet!G22","Test")
Note : It is very important to type the "#" pound sign before the sheet name insidequotes. It indicates that the location within the current workbook. Link will give you error if you forget to enter it.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
Jun 24 2020 02:20 AM
Jun 23 2020 01:18 PM
SolutionHi @niallfagan
The solution to your query work like this
=HYPERLINK("#MasterSheet!G22","Test")
Note : It is very important to type the "#" pound sign before the sheet name insidequotes. It indicates that the location within the current workbook. Link will give you error if you forget to enter it.
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more