Forum Discussion
Solved
Hyperlink referenced from another Sheet not working
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" a...
Hi 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
Hello,
You can try to do the hyperlink from sheet to sheet using another workbook just to be sure that its either working or not working on your system
You can try to do the hyperlink from sheet to sheet using another workbook just to be sure that its either working or not working on your system
Thanks for the response.
The hyperlink works fine by itself, as in If i click on it in sheet 2 it opens up without any issue. But when I reference it in sheet one it gives the error.
Thanks
Niall
The hyperlink works fine by itself, as in If i click on it in sheet 2 it opens up without any issue. But when I reference it in sheet one it gives the error.
Thanks
Niall