link to a specific tab of an other excel sheet

New Contributor

I need to link a cell to a specific tab of an other exceldoc. This might look like:


This formula works perfect for other tabs of the same exceldoc but not for an other exceldoc. 


Could someone help me with this one since I cannot find the answer on internet anywhere. 



2 Replies
Best Response confirmed by IsabellKramer (New Contributor)


The arguments of HYPERLINK must be text strings.

If the workbook is in the same folder as the one with the formula:


=HYPERLINK("[Exampledocexcel.xlsx]Blad4!F8";"Een of andere tekst")


If it is in another folder, you have to include the path:


=HYPERLINK("[C:\Excel\Exampledocexcel.xlsx]Blad4!F8";"Een of andere tekst")