Link diverts to c drive when emailed to colleagues
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
|