| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link diverts to c drive when emailed to colleagues
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? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link diverts to c drive when emailed to colleagues
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? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link diverts to c drive when emailed to colleagues
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? "bj" wrote: 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? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Link diverts to c drive when emailed to colleagues
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Link to Network Drive | Excel Discussion (Misc queries) | |||
| Link to Network Drive | New Users to Excel | |||
| Link to Network Drive | Links and Linking in Excel | |||
| Can I email my colleagues automatically when i update a workbook? | Excel Discussion (Misc queries) | |||
| Link workbooks-C drive to network drive | Excel Worksheet Functions | |||
Linear Mode
