Hyperlink problem 2003 to 2002 and 2000

  • Thread starter Thread starter Bob
  • Start date Start date
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?
 
Saving as an HTM will not help as users share the workbook. The hyperlinks
are to move users between worsheets in the workbook.
 
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)
 
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
 
Back
Top