Web Development

Ask something
Discussion Locked

Hyperlink Word to a specific Excel Sheet

0 helpful
6 replies

by cmincy

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 dklippert

Copy one cell from the sheet and paste link to see the format. Youl need quotes around DR Hotline.

Breakdown.xls#'DR Hotline'!

The "real field will look like:

\\Breakdown.xls"\1 "'DR Hotline'!A1"

This discussion is closed to new replies.