Solved

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

Posted on 2004-08-16
5
1,367 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

[Webinar] Learn How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them. Thursday, July 13, 2017 10:00 A.M. PDT

Question has a verified solution.

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

If you work with Word a lot, you probably use styles. If you use styles a lot, you've probably balled your fist more often than not when working with the ribbon. In Word 2007/2010, one of the things that I find missing when using styles is a quic…
This article describes how to use the Send to Mail Recipient command. The instructions apply generally to Office 2007 and later versions, but Microsoft® Word 2013 was used for the specific steps and figures.  What is Send to Mail Recipient? Send…
The viewer will learn how to make their project stand out over others by learning how to change colors and shapes, add spaces, change directions, and add bullets to their charts.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.

632 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