Using Hyperlinks in Excel on web
 

I have a hyperlink in Excel 2003 which links to another worksheet in the same
file. When I publish the file to our intranet, the users gets the following
message when they click on the link: "This document has been modified. Do you
want to save changes?" The user must click on No in order to be taken to the
new location.

I believe this happens because the link is an absolute path. Is there any
way to set up the hyperlink to be relative? How can I stop the message from
appearing?