Solved: Linking Excel files with hyperlinks

Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

elay

Thread Starter
Joined
Jan 20, 2006
Messages
65
I am doing some work for my husbands work (he taking all the credit) and they have requested that one Excell file be linked to another, which I have done quite easily using hyperlinks.

He has been asked if it is possible to link to a particular worksheet (tab) within that file and then a particular cell. Ive looked at Microsoft help which is pointing in the direction of "Function" which is confusing me, ive tried but cant get it to work, is there an easier way.

thanks
 

WhitPhil

Gone but never forgotten
Trusted Advisor
Joined
Oct 4, 2000
Messages
8,684
I "think" this is what you want ...

Select the cell within the tab within the file that you wish to link to. Then COPY.

Then, in the cell you wish to link, select it, right mouse, paste special, Paste Link Button.
 
Joined
Jul 1, 2005
Messages
8,546
Re: husband taking all the credit -- yeah, that'll happen. :D

(Please note: the following applies to Excel 2K, things may be different in 03)

Since I've never tried this, I had a bash. The first step is easy -- Insert > Hyperlink (or CTRL+K) to launch the "Insert HyperLink" dialog.

Under "Link to:", "Existing File or Web Page" must be selected since that "drives" the other options.

As long as "Existing File or Web Page" is selected, you should have a "Browse for file" button. Following that is fairly straightforward, you should end up with something like C:\test.xls under "Type file or web page name". Then you need to click the "Bookmark" button.

That gives you the "Select place in document" dialog. You can either type in the specific location within the file to link to, or do the navigation thing again.

When you click out of the "Select place in document" dialog (with "OK"), your "Type file or web page name" info should be updated to something like C:\test.xls#Sheet1!A1

From there, you just click "OK" to finish off.

HTH -- post back if it doesn't.

EDIT: added a screenshot that may help.
 

Attachments

elay

Thread Starter
Joined
Jan 20, 2006
Messages
65
Thats it bomb#21, thank you, its the "Bookmark" button that does the bit that I wanted.
 
Joined
Jul 1, 2005
Messages
8,546
To paraphrase BanditFlyer, another of our members, I'm not a Richard -- but you're welcome. ;)

You can use "Thread Tools" near the top of this page to mark the thread as solved if you wish. Enjoy. :)
 

elay

Thread Starter
Joined
Jan 20, 2006
Messages
65
sorry i looked at the last line, just realized its a quote. LOL
 
Status
This thread has been Locked and is not open to further replies. Please start a New Thread if you're having a similar issue. View our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Members online

Top