Hyperlink from Word to sheet in Excel

[Flo]

Hi everyone!

I'm trying to make a hyperlink in a word document to a chart-sheet in
an excel document. This hyperlink is supposed to have the following
features:
- no drive letter → I'm working on several machines. The file in
question is always in the same folder, but the drive letters differ.
- link directly to chart → I tried this in the address bar of the
hyperlink menu: " path/file.xls#'chart'!A1 " but since there are no
cells in a chart-sheet, I get an "invalid reference"-error-message.

I would be very grateful if anyone knows a solution to one of the
above.

Thank you,
Flo.

 

[Robert M. Franz (RMF)]

Hi Flo

I'm trying to make a hyperlink in a word document to a chart-sheet in
an excel document.

For once, it seems the entire blame goes to the Excel PG: they seem to
have forgotten to include an out-of-the-box method to link to a Chart
Sheet. :-(

See:

http://groups.google.com/group/micr...0c903f80a04?lnk=st&q=&rnum=2#099f70c903f80a04

Greetinx
Robert