SOLVED

link to a specific tab of an other excel sheet

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

1 best response

Accepted Solutions
best response confirmed by IsabellKramer (Copper 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")

View solution in original post