Hyperlink problem 2003 to 2002 and 2000

B

Bob

We have multi-sheet workbooks with hyperlinks between worksheets we create
in 2003. When we send to a 2000 or 2002 user, they cannot use the hyperlink.
Anyone know how to resolve?
 
B

Bob

Saving as an HTM will not help as users share the workbook. The hyperlinks
are to move users between worsheets in the workbook.
 
D

Dave Peterson

What happens when the xl2k/xl2002 user clicks the hyperlink?

How do you insert the hyperlink--are you using Insert|Link and pointing to a
drive/folder--maybe that's the problem.

I've used the =hyperlink() worksheet function and never had any trouble:

David McRitchie posted this and it might help you:

=HYPERLINK("#"&CELL("address",C5),C5)
=HYPERLINK("#"&CELL("address",sheetone!C5),sheetone!C5)
=HYPERLINK("#"&CELL("address",'sheet two'!C5),'sheet two'!C5)
 
D

David McRitchie

Like Dave Peterson said.

My guess is that you are using HYPERLINK Worksheet Function
if you are then Excel 2000 has a problem with
=HYPERLINK(sheet3!C5,sheet3!C5)

in Excel 2000 you would have to include the entire pathname,
or you can use the # in front and it will work in other versions that support
hyperlinks as well :
=HYPERLINK("#"&CELL("address",sheet3!C5),sheet3!C5) \\

If that is not the problem then you will have to indicate if the
hyperlinks that fail are Hyperlink Worksheet Function or object
hyperlinks. What the link is -- how it is coded. And exactly what
error message you get if any.

More information in
http://www.mvps.org/dmcritchie/excel/sheets.htm#hyperlink
 
Top