I am trying to hyperlink from one workbook to another. Aside from opening the destination workbok with the hyperlink, I would also like to display the value of a specific cell that resides in the destination workbook within the cell of the original workbook that contains the hyperlink.

I tried this at Mr. Excel but was told that a hyperlinked cell cannot be used to display a value from another workbook. But I do not think that is correct.

You can do this:

- Take the workbook (1st) you want to create the externally linked hyperlink in and open it
- Also open the other workbook (2nd) that you want to link / hyperlink to
- In the 1st workbook in any cell start typing a formula (by typing =)
- Whilst still editing the formula switch to the 2nd workbook (by pressing Ctrl + F6 amongst other ways)
- Navigatve to the desired sheet in the 2nd workbook by clicking on the sheet tabs at the bottom
- Click on the cell whose value you'd like to externally link
- Press Enter
- Switch back to the 2nd workbook and close it
- In the first workbook click on the externally linked cell which will show the value of the other spreadsheet's cell
- Press Ctrl + K to bring up the Edit Hyperlinks dialog box
- Use the file browse dialog to navigate to the linked file (2nd workbook)
- Select the linked file and press ok
- You will have an externally linked hyperlinked cell