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.
Ben_FosterAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
anikmankarConnect With a Mentor Commented:
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
 
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
 
Anne TroyEast Coast ManagerCommented:
Or insert a named range into the excel file and put #RangeName
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.