Solved

Inserting hyperlink in Word to link to specific worksheet in an Excel file

Posted on 2004-08-16
5
1,330 Views
Last Modified: 2008-01-09
I want to insert a hyperlink into a MS Word document to link to a specific worksheet within an Excel file.
0
Comment
Question by:Ben_Foster
5 Comments
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 11811167
You should be able to do that.... click on the Excel sheet you want to hyperlink to and close the file.

Then just create your hyperlink to the file and it should open up to the page you want.

HTH

0
 

Author Comment

by:Ben_Foster
ID: 11813971
What if you wanted to create multiple links in the Word document that opens different sheets in the Excel file.
0
 
LVL 37

Expert Comment

by:Joanne M. Orzech
ID: 11814887
I'm sorry - I'm not aware of a way to do that...but some of the other experts have some ideas...
0
 

Accepted Solution

by:
anikmankar earned 125 total points
ID: 11815251
Add the Sheet name at the End seperatign the file and the sheet by a # As follows "Book1.xls#Sheet1!A1" - that should work
0
 
LVL 22

Expert Comment

by:Dreamboat
ID: 11816583
Or insert a named range into the excel file and put #RangeName
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

Like many others, we try and discourage users from printing documents unnecessarily and instead send or share them electronically. However, this doesn't always work and documents are still printed. With this simple solution, if the user tries to …
Using Word 2013, I was experiencing some incredible lag when typing.  Here's what worked for me....
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

920 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

15 Experts available now in Live!

Get 1:1 Help Now