Solved

Are there SHORTCUTS to open a linked workbook?

Posted on 2011-02-16
4
261 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

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…
Convert between Excel file formats (.XLS, .XLSX, .XLSM) with/without macro option David Miller (dlmille) Intro Over this past Fall, I've had the opportunity to see several similar requests and have developed a couple related solutions associate…
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.

930 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now