• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 330
  • Last Modified:

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.
0
brothertruffle880
Asked:
brothertruffle880
  • 2
1 Solution
 
FernandoFernandesCommented:
we can help you write a macro to do so, and associate it with a shortcut key ...
0
 
Let's GoCommented:
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
 
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

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now