Quick question I am hoping someone might be able to assist with,

Our users have a joint excel workbook that is linked to other .docs and
.xls's, so when they open their workbook it fills in the excel lines
automatically via a formula that obtains that info from the other
documents.

If they open the excel workbook from a UNC folder, ie.
\\server\\share\workbook.xls - it works great.

However, if they open it via relative (mapped) drive folder, ie.
I:\fin\workbook.xls - the formulas dont work properly and they just get
a whole bunch of NA's instead of data.

My Question: Is there a way to force Excel (2003) to ALWAYS use UNC's
instead of changing them to relative (mapped)? Is there a registry key,
or patch, or......

thanks in advance!
Andrew