SOLVED

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:

=HYPERLINK('[Exampledocexcel.xlsx]Blad4'!;F8)

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. 

Thanks!

 

2 Replies
Best Response confirmed by IsabellKramer (New Contributor)
Solution

@IsabellKramer 

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")