Solved

Are there SHORTCUTS to open a linked workbook?

Posted on 2011-02-16
4
263 Views
Last Modified: 2012-05-11
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
Comment
Question by:brothertruffle880
  • 2
4 Comments
 
LVL 6

Expert Comment

by:FernandoFernandes
ID: 34909034
we can help you write a macro to do so, and associate it with a shortcut key ...
0
 
LVL 6

Accepted Solution

by:
Let's Go earned 500 total points
ID: 34912593
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
 
LVL 85

Expert Comment

by:Rory Archibald
ID: 34914796
On the Data tab, click on the Edit Links button, then you can open the source workbook from the list there.
0
 
LVL 6

Expert Comment

by:Let's Go
ID: 35053358
brothertruffle880,

Do you need any more information?
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Improved? Move/Copy Add-in Replacement - How to avoid the annoying, “A formula or sheet you want to move or copy contains the name XXX, which already exists on the destination worksheet.” David Miller (dlmille)  It was one of those days… I wa…
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

803 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question