Hi Group,

I use the following code (provided previously by this Group) which
allows me to navigate a worksheet using an index style system. It
works well within my Excel workbook.

=HYPERLINK("#'Email'!"&ADDRESS(MATCH(C6,Email!$C$4 0:$C$7640,0)+39,3),"View
Parts")

I now have a need to email this worksheet on a weekly basis to some
colleagues (due to file size I cannot send full spreadsheet) but the
the hyperlinks don't work correctly when viewed in Outlook. The
following error message appears in the bottom left hand corner when I
hover a link and nothing happens "mhtml:mid://00000000/#'Email'!$A$204"
..

Is there a way around this or is this just a drawback with the
Hyperlink function.

grateful for advice/thoughts

Tony