I created a link using the "create hyperlink" button. This links to a
directory on my drive. I test the link and it works. The instant I save the
file, the link breaks and no longer works. Editing the link shows that excel
has changed the link into something cryptic. It doesn't even point to the
right DRIVE anymore.

Can anyone tell me what I am doing wrong?

Thanks!