Link to other excel documents

[BuRn3R]

Hey all, I am managing a lot of information spread across three exccel documents (with multiple sheets in those documents). I am creating a master document that displays where I can find all the different types of information.

I was wondering if there was a way I could make a cell be able to link to a separate excel file. I have a list created that have the name of the 3 excel sheets, basically I would like the value of that list to be able to link to its corresponding excel doc.

For example:

List = Tom, Jerry, Eric

If I click on Tom, Tom.xls opens to the sheet with the information I need.

Is this doable?

[JBeaucaire]

Click on the TOM cell and press CTRL-K to open the HYPERLINK window. Find the Tom.xls file and select it.

Now the cell has a hyperlink in it and you can click it anytime.

[ravishankar]

Hi
Select cell containing Tom (or others), Goto INSERT menu > Hyperlink > Browse for : FILE > choose the file (click OK) > Click OK
Repeat for other files.
Ravi

[BuRn3R]

Thanks a bunch!

Lets say Tom.xls has multiple sheets, and I want it to open to sheet 2. Is this possible?

[BuRn3R]

Does anybody know if this is possible? Having the hyperlink open the file to a specific sheet, instead of just opening up to the default page?

[JBeaucaire]

Click on the cell with TOM
Ctrl-K to open the Hyperlink Window
Locate and highlight your Tom.xls file in the main window
Click on BOOKMARK to open a subwindow of Tom.xls sheets and named ranges
Select the sheet you want and click OK.
Ok.

[BuRn3R]

Thank you very much, this is a huge help!! Works just like you say. Thanks!!

[JBeaucaire]

If that takes care of your need, be sure to EDIT your original post (Go Advanced) and mark the PREFIX box [SOLVED].



(Also, use the "scales" icon in our posts to leave Feedback, it is appreciated)