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?

Save it as a htm?

"Bob" wrote:

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

"Bob" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>

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)

Bob wrote:
>
> 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?

--

Dave Peterson

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....htm#hyperlink
--
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob" <(E-Mail Removed)> wrote in message news:%23cs%(E-Mail Removed)...
> Saving as an HTM will not help as users share the workbook. The hyperlinks
> are to move users between worsheets in the workbook.
>
> "Bob" <(E-Mail Removed)> wrote in message
> news:(E-Mail Removed)...
> > 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?
> >
>
>