The Excel HYPERLINK function is a useful method of allowing users to navigate around sheets. Unfortunatly Excel only allows hyperlinks to specific cells in a workbook. This makes it impossible to use a hyperlink to jump to a Chart or Worksheet without change the cell reference.
I have written a small program that uses the "excel://" protocol to allow it to process links to excel workbooks. Some example hyperlinks are:
=HYPERLINK("excel://B8")
=HYPERLINK("excel://[Book2]Sheet3!A2")
=HYPERLINK("excel://Chart1")
Note: the protocol ("excel://") is all in lowercase. I may fix this later.
You can download a windows msi file for this program here, and the source is available here.