Forum Discussion
Solved
link to a specific tab of an other excel sheet
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 ...
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")
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")
HansVogelaarThank you!!