Link to Workbooks in Separate File Excel 2016

[Elljay87]

Hi all!
I am being asked by a co-worker if this can be done. She wants to create a file that will contain links to workbooks in 3 separate files.
One main file with active links to several workbooks in 3 others. I've done research and currently use ASAP Utilities but I am not finding anything. Can anyone offer some insight?

Thank you!
LJ

 

[The_Macrotect]

Hi LJ,

Are you looking to place hyperlinks in the main excel file to access other files when the link is clicked on? If so, try the following:

1) Right click on the cell where you want the link to be.
2) Select the "Hyperlink..." option
3) In the "Text to display" field, type what you'd like the link text to be
4) Type the file path in the "Address" field or browse for the file you'd like the link to open

 

[Elljay87]

Macrotect thank you!! I do believe that is the solution, thanks so much for your quick reply!