Reference is not valid

[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.

 

[Eddy]

To my knowledge, you can only use hyperlink to open a workbook, not to a
worksheet.

 

[Dave Peterson]

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)