Making Links relative to the current directory

[cherria]

When I view my links, they are always absolute back to the server name or drive letter which means that if I copy an entire directory to a new location the links no longer work.

Is there a way to make th elinks relative to the location of the workbook that they are in.

So perhaps if I wanted to link to a file called test.xls in the directory one under where I am I could use ='..\text.xls[sheet1]'!A1 or something like that.

Is this possible.

 

[cherria]

Thought I'd bump this up again

 

[cherria]

And one last try now that the US is back at their desks after a holiday.

 

[Tester1]

I have this exact problem...
No answers means no solution?? :'( buaaaa...

May be, one year later, there is a solution!