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...

excel

Formulas and Functions

ExcelExciting
Jun 23, 2020
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

ExcelExciting

MVP

Jun 23, 2020

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