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.
 
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)
 
Back
Top