I am using a function to do a lookup on external shared spreadsheet. The
formula goes like this:
VLOOKUP(D$2,[Joblist.xls]Sheet1!$A$2:[Joblist.xls]Sheet1!$B$301,2,FALSE)
This works great. However, on another machine, Excel replaces
[Joblist.xls]Sheet1 with 'T:\office\[Joblist.xls]Sheet1'.
Why is this being replaced, and how do I get rid of the compete path? Is
there an option setting that is causing this?

Thanks in advance.