Are there SHORTCUTS to open a linked workbook?

I have a cell in my current Excel workbook and would like to know if there a quick way to open the workbook whose cell contents are referred to in my cell.

All I can think of is to press F2, Copy the location of the workbook, and paste it in the address line of a browser, clean up the square brackets and equal signs and then press ENTER.
brothertruffle880Asked:
Who is Participating?
 
Let's GoConnect With a Mentor Commented:
Here is an example.

Cell A1 has the contents: C:\temp\test excel file.xlsx

In Cell A2, enter the formula =HYPERLINK("file://"&A1)
That will create a hyperlink that you can click to open the file.

Alternatively, pressing ctrl-k will open a dialogue box to create a new hyperlink
0
 
FernandoFernandesCommented:
we can help you write a macro to do so, and associate it with a shortcut key ...
0
 
Rory ArchibaldCommented:
On the Data tab, click on the Edit Links button, then you can open the source workbook from the list there.
0
 
Let's GoCommented:
brothertruffle880,

Do you need any more information?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.