I have a Hyperlink in my worksheet that points to a document on our network
server, but when I save this file and email it to the group the hyperlink
changes to point to my hard drive where the document is not located.

Tools - Options - General - Web Options - Files - Uncheck update links
on save doesn't work. Also, I erased the file default location as this was
pointing to my hard drive; this seemed to work for awhile but not any more.