SOLVED

Hyperlink referenced from another Sheet not working

%3CLINGO-SUB%20id%3D%22lingo-sub-1476812%22%20slang%3D%22en-US%22%3EHyperlink%20referenced%20from%20another%20Sheet%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1476812%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3EIn%20%22Sheet1%22I%20am%20trying%20to%20reference%20a%20Hyperlink%20from%20another%20sheet%20%22MasterSheet%22.%20But%20i%20am%20getting%20%22Cannot%20Open%20Specified%20File%22%20error.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20i%20just%20type%20the%20URL%20in%20the%20cell%20in%20%22MasterSheet%22%20and%20reference%20it%20in%20sheet%201%20it%20works%20fine.%20Unfortunately%20this%20isn't%20good%20enough%2C%20i%20want%20to%20use%20a%20Hyperlink%20so%20i%20can%20have%20the%20file%20name%20that%20the%20URL%20is%20pointing%20to%20viable%20in%20%22Sheet1%22%20for%20example%26nbsp%3B%22Document%20A%22%20.%26nbsp%3B%3C%2FP%3E%3CP%3EFrom%20reading%20other%20treads%20i%20tried%20using%20the%20Hyperlink%20function%20but%20this%20didn't%20fix%20the%20problem%20either.%3C%2FP%3E%3CP%3E%3DHYPERLINK(MasterSheet!G22%2C%22Test%22).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20make%20this%20more%20complicated%20i%20am%20using%20a%20lookup%20table%20to%20determine%20which%20cell%20to%20reference%2C%20but%20that's%20another%20days%20problem.%20I%20have%20the%20lookuptable%20part%20working%20so%20hopefully%20if%20i%20can%20get%20the%20hyperlink%20part%20working%20by%20itself%20i%20can%20throw%20it%20into%20the%20lookup%20formula%20without%20much%20fuss.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20someone%20please%20help.%20My%20heads%20fit%20to%20explode%20with%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20in%20Advance%3C%2FP%3E%3CP%3ENiall%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1476812%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1479372%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlink%20referenced%20from%20another%20Sheet%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479372%22%20slang%3D%22en-US%22%3EHello%2C%20%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20try%20to%20do%20the%20hyperlink%20from%20sheet%20to%20sheet%20using%20another%20workbook%20just%20to%20be%20sure%20that%20its%20either%20working%20or%20not%20working%20on%20your%20system%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1479378%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlink%20referenced%20from%20another%20Sheet%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1479378%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20response.%3CBR%20%2F%3EThe%20hyperlink%20works%20fine%20by%20itself%2C%20as%20in%20If%20i%20click%20on%20it%20in%20sheet%202%20it%20opens%20up%20without%20any%20issue.%20But%20when%20I%20reference%20it%20in%20sheet%20one%20it%20gives%20the%20error.%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3ENiall%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1484594%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlink%20referenced%20from%20another%20Sheet%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1484594%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F704576%22%20target%3D%22_blank%22%3E%40niallfagan%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThe%20solution%20to%20your%20query%20work%20like%20this%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DHYPERLINK(%22%23MasterSheet!G22%22%2C%22Test%22)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENote%20%3A%20%3CSPAN%3EIt%20is%20very%20important%20to%20type%20the%20%22%23%22%20pound%20sign%26nbsp%3Bbefore%20the%20sheet%20name%20insidequotes.%20%3C%2FSPAN%3E%3CSPAN%3EIt%20indicates%20that%20the%20location%20within%20the%20current%20workbook.%20Link%20will%20give%20you%20error%20if%20you%20forget%20to%26nbsp%3Benter%20it.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3ERegards%2C%20Faraz%20Shaikh%20%7C%20MCT%2C%20MIE%2C%20MOS%20Master%2C%20Excel%20Expert%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CEM%3E%3CFONT%20color%3D%22%23808080%22%3EIf%20you%20find%20the%20above%20solution%20resolved%20your%20query%20don't%20forget%20mark%20as%26nbsp%3B%3CSPAN%3EOfficial%20Answer%26nbsp%3Bto%20help%20the%20other%20members%20find%20it%20more%3C%2FSPAN%3E%3C%2FFONT%3E%3C%2FEM%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1485521%22%20slang%3D%22en-US%22%3ERe%3A%20Hyperlink%20referenced%20from%20another%20Sheet%20not%20working%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1485521%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F156456%22%20target%3D%22_blank%22%3E%40Faraz%20Shaikh%3C%2FA%3E%26nbsp%3Bfor%20the%20reply.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20think%20it%20have%20it%20now.%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%20for%20your%20feeback%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENiall%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

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

4 Replies
Highlighted
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
Highlighted
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
Highlighted
Best Response confirmed by niallfagan (New Contributor)
Solution

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

Highlighted

Thanks @Faraz Shaikh for the reply. 

I think it have it now. 

Thanks for your feeback

 

Niall