Excel Hyperlinks changing on their own

[tbrand68]

I've set up an excel workbook with links to other files... I call it the
index workbook.
I use excel 2003.

This is what is happening:
1. I type the word Aug FY05 Report
2. I click on the hyperlink icon and browe to the location of the file:
k:\reports\FY05\Cyberquery Reports\Aug Fy05.cqe
3. Click OK
If I click on the cell with the link, it works fine....
UNTIL I save the file...
Then the hyperlink changes to:
file://\\datasrv6\departments\reports/FY05/Cyberquery Reports/FY05.cqe
Notice how the backslashes have changed to forward slashes....

The K drive is mapped to \\datasrv6\departments on each client machine.
I've tried chaning the Base Hyperlink location in the properties of the
excel workbook to K: and to \\datasrv6 and to k:\reports and to
\\datasrv6\departments and have left it blank also... Nothing has worked...

Anyone know how to make excel link to a specific file and not change the
hyperlink to what it "thinks" it should be... kind of like an absolute $a$1
reference?

Thanks in advance, I'm desparate to get an answer...

Tim

 

[Nancy]

I'm no help except to console....I have the exact same problem, but I see no
one has answered you yet. I've tried exactly what you did.

 

[Bob I]

Trt putting in the "correct absolute" one yourself.(using the server
name and path instead of the "variable" mapped path.