Solved

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

Posted on 2004-08-16
5
1,361 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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Introduction This tutorial provides instructions on how to properly format your Word document using the inbuilt tools provided. The benefits of using these tools means your documents are more accessible and easily portable to other applications an…
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…
This video shows where to find templates, what they are used for, and how to create and save a custom template using Microsoft Word.
In a previous video Micro Tutorial here at Experts Exchange (http://www.experts-exchange.com/videos/1358/How-to-get-a-free-trial-of-Office-365-with-the-Office-2016-desktop-applications.html), I explained how to get a free, one-month trial of Office …
Suggested Courses

734 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