Link diverts to c drive when emailed to colleagues

[Guest]

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?

 

[Guest]

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.

 

[Guest]

The link that changes is a vlookup funtion to another workbook. Opening both
my operating file and the datasource, when adding the the indirect funtion -
the cell only ref's out.

any other suggestions?

 

[Dave Peterson]

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)

 

[Guest]

Seems to have done the trick.

Thank you

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)

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?