Here is the problem. I do a lot of work on spreadsheets at home for use at work. We use a shared drive on the server at work, it is mapped to "S:" drive. I mapped an "S:" drive on my home machine so I could create Hyperlinks as a mirror of the drive at work. Whenever I create a Hyperlink at home, excel changes it from the drive letter "S:" to my computer name and share. ie \\awwall\c$. I want excel to use the mapped drive letter "S:". Is this possible?

Using Excel 2007 with SP1

Thanks
AW