Feb 03 2021 01:36 AM
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!
Feb 03 2021 03:15 AM
SolutionThe 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")
Feb 03 2021 03:15 AM
SolutionThe 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")