Reference is not valid

  • Thread starter Thread starter Crystal
  • Start date Start date
C

Crystal

Opening an excel worksheet (have many worksheets in a
workbook) using a hyperlink from Word gets
error "Reference is not valid". My hyperlink is
filename#'worksheet!a1'. Help please.
 
To my knowledge, you can only use hyperlink to open a workbook, not to a
worksheet.
 
I added a hyperlink in Word2002 (ctrl-k) and used this format:

C:\My Documents\excel\book1.xls#'sheet2'!c99

It seemed to work ok. (Opened to sheet2 cell c99)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

minus signs, or dashes in a formula or hyperlink 3
Hyperlink failure after saving document 2
When sharing, can I force an Excel document to open in a certain view? 0
Adding a hyperlink to a picture in Excel 2007 3
Hyperlink via indirect cell reference 8
Hyperlink Help 4
Data Validation 2
Hyperlink - reference not valid 2

Back
Top