• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1379
  • Last Modified:

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

I want to insert a hyperlink into a MS Word document to link to a specific worksheet within an Excel file.
0
Ben_Foster
Asked:
Ben_Foster
1 Solution
 
Joanne M. OrzechManager, Document Services CenterCommented:
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
 
Ben_FosterAuthor Commented:
What if you wanted to create multiple links in the Word document that opens different sheets in the Excel file.
0
 
Joanne M. OrzechManager, Document Services CenterCommented:
I'm sorry - I'm not aware of a way to do that...but some of the other experts have some ideas...
0
 
anikmankarCommented:
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
 
DreamboatCommented:
Or insert a named range into the excel file and put #RangeName
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now