Solved

Are there SHORTCUTS to open a linked workbook?

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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Approximate matching with VLOOKUP and MATCH seems to me to be a greatly under-used technique, and one which is vital for getting good performance out of large lookups. Until recently I would always have advised using an exact match for simplicity an…
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…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

828 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