Solved

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

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

ScreenConnect 6.0 Free Trial

Explore all the enhancements in one game-changing release, ScreenConnect 6.0, based on partner feedback. New features include a redesigned UI, app configurations and chat acknowledgement to improve customer engagement!

Question has a verified solution.

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

There is a feature provided by MS Word that lets you create an Table of Contents for your Word document automatically. To use this feature for other documents there are two steps involved,   1.  Prepare your document for a table of contents (he…
Shortcuts in Word Just the other day I had a training for Microsoft and they wanted me to show how well the new Windows and Office behaved on a touch device, which by the way is great, but it was only then that I realized that using keyboard shortc…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
Learn how to make your own table of contents in Microsoft Word using paragraph styles and the automatic table of contents tool. We'll be using the paragraph styles in Word’s Home toolbar to help you create a table of contents. Type out your initial …

832 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