Discussion Locked
0 helpful
6 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I am trying to insert a hyperlink in a Word 2000 doc. to a specific sheet in an Excel 2000 workbook. On the word doc. I click the insert Hyperlink, browse file and choose the Excel workbook. What do I need to insert after the Workbook name to make it go to Sheet 3 or do I need to set up a Macro to make it point to Sheet 3 and how do I do that? Thanks A Novice
6 replies
by dklippert
If you use the Hyperlink icon on the toolbar, or Insert Hyperlink, or Ctrl+K, search for the Excel file and then after the link, enter #Sheet3!A1
such as:
C:\Spreadsheets\Fred.xls#Sheet3!A1
If you select the link and then hit Alt+F9 you'll see that the "real" field is:
{ HYPERLINK "C:\\Spreadsheets\\Fred.xls" \1"Sheet3!A1"}
by cmincy
The path in simular to the following\\It_ser\fdrive\GRPS\IT_OP\Disaster Recovery Plan\24.00 Contacts\External Contacts Breakdown.xls#Sheet3!A1. It takes me to the workbook but I get "Reference is Not Valid" I replaced the Sheet3 with the name of theSheet .....Breakdown.xls#DR Hotline!A1 and I get the same message. The # works if you link to a workbook with one sheet only using the column and line number.
by dklippert
Use the Hyperlink icon to browse to the file location. then add:
#sheet3!A2
(or any name you have chosen for the tab)immediately following the address.
Try using a named range such as:
C:\Spreadsheets\SpreadsheetA.XLS#SalesTotal
It does work!
by cmincy
This question was closed by the author
This discussion is closed to new replies.
Trending Web Development posts
Sort by Trending
1 helpful
3 replies
Discussion Locked
What Makes a Business Website Effective in 2026
2 helpful
10 replies
Question Unanswered
Best Way to Make Long WordPress Location Guides Mobile Friendly
0 helpful
0 replies
Question
Windows and macOS computers becoming slow or unstable after updates - what should I check first
0 helpful
1 reply
Discussion
Optimizing WordPress widgets and DOM size
0 helpful
3 replies