one way is to rewrite the equations using the indirect function, so that the
referece will stay the same no matter where the program is run from.

"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?