Seems to have done the trick.

Thank you


"Dave Peterson" wrote:

Do you use the mapped drive letter (K:) in your formulas?

If you do, you may want to try replacing them with the UNC path instead.

='k:\somepath\[book1.xls]Sheet1'!$A$1
becomes
='\\sharename\somepath\[book1.xls]Sheet1'!$A$1

(Untested)

knghtrvn wrote:

Weekly I send out files to be completed and returned. Budget data is linked
to a datatable on our servers k drive. Whenever I email the file - the link
switches from k: to c: or worse, the whole path changes to their local
settings.

How can I stop this from happening?

--

Dave Peterson