SOLVED
Home

HYPERLINK function returns "Cannot open specified file"

%3CLINGO-SUB%20id%3D%22lingo-sub-286068%22%20slang%3D%22en-US%22%3EHYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286068%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20use%20the%20HYPERLINK%20function%20but%20to%20no%20avail.%20I%20have%20exhausted%20all%20the%20standard%20help%20available%20on%20this%2C%20but%20I%20cannot%20figure%20out%20what%20is%20wrong%2C%20Here%20is%20an%20example%20of%20the%20syntax%20I%20am%20trying%20to%20use%20to%20hyperlink%20to%20a%20cell%20on%20the%20same%20tab%20of%20a%20spreadsheet%3A%20%3DHYPERLINK(%24U%2414%2C%22Table%2020-09%22).%20When%20I%20use%20the%20Insert%20Hyperlink%20functionality%2C%20it%20works%20fine.%20However%2C%20I%20have%20to%20use%20the%20HYPERLINK()%20function%20because%20it%20needs%20to%20work%20dynamically%20(with%20a%20passed%20cell%20reference).%20The%20sheet%20is%20not%20protected%20(at%20this%20point).%20Using%20Office%20365.%20A%20solution%20to%20this%20problem%20will%20be%20greatly%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-286068%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-443748%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-443748%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20This%20did%20solve%20my%20problem%20with%20the%20error%20messages%20I%20was%20getting%20but%20its%20not%20dynamic%20and%20moving%20when%20rows%20are%20added%20in.%20Please%2C%20can%20you%20help%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3DHYPERLINK(%22%23Sheet1!A20%22%2C%20%22Fuel%20Systems%22)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F89704%22%20target%3D%22_blank%22%3E%40Damien%20Rosario%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314965%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314965%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%2F126121%22%20target%3D%22_blank%22%3E%40Jamie%20Sutherland%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20suggesting%20that%20sometimes%2C%20accidentally%2C%20a%20space%20could%20be%20after%20the%20sheet%20name%20which%20isn't%20visible%20to%20the%20eye%20but%20might%20be%20sitting%20there%20as%20space%20is%20a%20character.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnyway%2C%20the%20only%20other%20option%20I%20can%20think%20of%20to%20fix%20the%20issue%20is%20to%20recreate%20your%20sheets%20in%20a%20new%20workbook%20and%20see%20if%20that%20fixes%20the%20problem%20which%20is%20not%20ideal%20but%20may%20be%20worthwhile%20in%20the%20long%20run.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314964%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314964%22%20slang%3D%22en-US%22%3E%3CP%3Eactually%2C%20i%20can%20use%20your%20formulas%20on%20a%20new%20excel%20workbook%2C%20just%20not%20in%20my%20existing%26nbsp%3B%3CSPAN%3Eworkbook.%20as%20you%20will%20see%20in%20the%20attached%20jpg%20each%20tab%2Fsheet%20is%20a%20single%20name%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314960%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314960%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%2F126121%22%20target%3D%22_blank%22%3E%40Jamie%20Sutherland%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20what%20the%20issue%20is.%20Try%20simulating%20in%20a%20new%20Workbook%20to%20see%20if%20you%20still%20have%20the%20same%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheck%20your%20tab%20doesn't%20have%20any%20spaces%20in%20the%20name%20as%20well.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOtherwise%2C%20might%20need%20to%20log%20a%20support%20ticket%20with%20Microsoft%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20you%20figure%20it%20out!%20Let%20me%20know%20if%20any%20of%20the%20above%20works%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314959%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314959%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHey%20Damien%2C%3C%2FSPAN%3E%3C%2FP%3E%3CDIV%3Ethanks%20for%20getting%20back%20to%20me.%20curiously%2C%20both%20hyperlinks%20give%20me%26nbsp%3B%22an%20unexpected%20error%20has%20occurred%22.%20i'm%20starting%20to%20think%20there%20may%20be%20a%20bug%20in%20MS%20Excel.%3C%2FDIV%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314956%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314956%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%2F126121%22%20target%3D%22_blank%22%3E%40Jamie%20Sutherland%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGive%20this%20formula%20a%20try%20for%20linking%20within%20the%20same%20workbook%3A%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3DHYPERLINK(%22%23TEMPLATE!C1%22%2C%22Go%20to%20TEMPLATE%20%26gt%3B%20C1%22)%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EIn%20terms%20of%20using%20other%20cells%20to%20piece%20together%20a%20hyperlink%20(this%20example%20uses%20%2C%26nbsp%3Bcopy%20and%20try%3A%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%3CSTRONG%3E%3DHYPERLINK(%22%23%22%26amp%3B%22'%22%20%26amp%3B%20B3%20%26amp%3B%20%22'!%22%20%26amp%3B%20A1%2C%20%22Go%20To%20Sheet%22)%3C%2FSTRONG%3E%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20how%20you%20go%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-314945%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-314945%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Damien%2C%3C%2FP%3E%3CP%3Emy%20hyperlinks%20dont%20go%20to%20the%20corresponding%20sheet.%20all%20get%20errors.%3C%2FP%3E%3CP%3Ei%20have%20tried%20different%20hyperlink%20formulas.%26nbsp%3Bplease%20see%20my%20screenshots.%3C%2FP%3E%3CP%3Efor%20example%2C%20in%20my%20first%20screenshot%2C%20when%20i%20select%20the%20first%20(blue)%20link%20at%20the%20top%20of%20the%20screen%2C%20i%20get%20%22an%20unexpected%20error%20has%20occurred.%3C%2FP%3E%3CP%3Ei%20get%20the%20same%20response%20when%20i%20select%20the%20(black)%20link%20under%20it.%3C%2FP%3E%3CP%3Ethe%20thrid%20image%20show%20my%20spreadsheet%20in%20its%20whole.%3C%2FP%3E%3CP%3Ecan%20you%20see%20what%20is%20causing%20the%20errors%3F%3C%2FP%3E%3CP%3Ethanks%20for%20your%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-287437%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-287437%22%20slang%3D%22en-US%22%3ENice%20one%20guys!%20Willy%2C%20haven't%20seen%20you%20in%20a%20while.%20Good%20to%20see%20you%20around.%3CBR%20%2F%3E%3CBR%20%2F%3EHave%20a%20great%20weekend%20all!%3CBR%20%2F%3E%3CBR%20%2F%3ECheers%3CBR%20%2F%3EDamien%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-287328%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-287328%22%20slang%3D%22en-US%22%3EThank%20you%20for%20offering%20to%20help%2C%20but%20I%20got%20the%20problem%20resolved.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-287327%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-287327%22%20slang%3D%22en-US%22%3EThank%20you%20very%20much!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-286551%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286551%22%20slang%3D%22en-US%22%3E%3CPRE%3E%3DHYPERLINK(%22%23%24A%243%22%2C%22Somewhere%20in%20the%20same%20worksheet%22)%3C%2FPRE%3E%3CP%3Eor%3C%2FP%3E%3CPRE%3E%3DHYPERLINK(%22%23'ANOTHER%20SHEET'!%24A%243%22%2C%22Somewhere%20in%20another%20worksheet%22)%3C%2FPRE%3E%3CP%3Eif%20you%20want%20a%20dynamic%20link%20in%20cell%20A3%2C%20put%3C%2FP%3E%3CPRE%3E%23A5%3C%2FPRE%3E%3CP%3Ethen%2C%20the%20hyperlink%20function%3C%2FP%3E%3CPRE%3E%3DHYPERLINK(%24A%243%2C%20%22Somewhere%20pointed%20by%20Cell%20A3%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-286285%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-286285%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%2F241745%22%20target%3D%22_blank%22%3E%40Jan%20Grobbelaar%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%20a%20sample%20screen%20shot%20to%20share%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-683782%22%20slang%3D%22en-US%22%3ERe%3A%20HYPERLINK%20function%20returns%20%22Cannot%20open%20specified%20file%22%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-683782%22%20slang%3D%22en-US%22%3EYou%20may%20try%3CPRE%3E%3DHYPERLINK(%22%23Sheet1!%22%20%26amp%3B%20ADDRESS(ROW(A20)%2CCOLUMN(A20))%2C%20%22Fuel%20Systems%22)%3C%2FPRE%3E%3C%2FLINGO-BODY%3E
Jan Grobbelaar
New Contributor

I am trying to use the HYPERLINK function but to no avail. I have exhausted all the standard help available on this, but I cannot figure out what is wrong, Here is an example of the syntax I am trying to use to hyperlink to a cell on the same tab of a spreadsheet: =HYPERLINK($U$14,"Table 20-09"). When I use the Insert Hyperlink functionality, it works fine. However, I have to use the HYPERLINK() function because it needs to work dynamically (with a passed cell reference). The sheet is not protected (at this point). Using Office 365. A solution to this problem will be greatly appreciated.

13 Replies

Hi @Jan Grobbelaar

 

Do you have a sample screen shot to share?

 

Cheers

Damien

Solution
=HYPERLINK("#$A$3","Somewhere in the same worksheet")

or

=HYPERLINK("#'ANOTHER SHEET'!$A$3","Somewhere in another worksheet")

if you want a dynamic link in cell A3, put

#A5

then, the hyperlink function

=HYPERLINK($A$3, "Somewhere pointed by Cell A3")
Thank you very much!
Thank you for offering to help, but I got the problem resolved.
Nice one guys! Willy, haven't seen you in a while. Good to see you around.

Have a great weekend all!

Cheers
Damien

Hi Damien,

my hyperlinks dont go to the corresponding sheet. all get errors.

i have tried different hyperlink formulas. please see my screenshots.

for example, in my first screenshot, when i select the first (blue) link at the top of the screen, i get "an unexpected error has occurred.

i get the same response when i select the (black) link under it.

the thrid image show my spreadsheet in its whole.

can you see what is causing the errors?

thanks for your help.

Hi @Jamie Sutherland

 

 

Give this formula a try for linking within the same workbook:

=HYPERLINK("#TEMPLATE!C1","Go to TEMPLATE > C1")

 

In terms of using other cells to piece together a hyperlink (this example uses , copy and try:

=HYPERLINK("#"&"'" & B3 & "'!" & A1, "Go To Sheet")

 

See how you go?

 

Cheers

Damien

Hey Damien,

thanks for getting back to me. curiously, both hyperlinks give me "an unexpected error has occurred". i'm starting to think there may be a bug in MS Excel.

Hi @Jamie Sutherland

 

Not sure what the issue is. Try simulating in a new Workbook to see if you still have the same issue?

 

Check your tab doesn't have any spaces in the name as well.

 

Otherwise, might need to log a support ticket with Microsoft?

 

Hope you figure it out! Let me know if any of the above works?

 

Cheers

Damien

actually, i can use your formulas on a new excel workbook, just not in my existing workbook. as you will see in the attached jpg each tab/sheet is a single name

Hi @Jamie Sutherland

 

I was suggesting that sometimes, accidentally, a space could be after the sheet name which isn't visible to the eye but might be sitting there as space is a character.

 

Anyway, the only other option I can think of to fix the issue is to recreate your sheets in a new workbook and see if that fixes the problem which is not ideal but may be worthwhile in the long run.

 

Cheers

Damien

Hi, This did solve my problem with the error messages I was getting but its not dynamic and moving when rows are added in. Please, can you help?

 

=HYPERLINK("#Sheet1!A20", "Fuel Systems")

 

@Damien Rosario 

You may try
=HYPERLINK("#Sheet1!" & ADDRESS(ROW(A20),COLUMN(A20)), "Fuel Systems")
Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
46 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
30 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies