Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixing a link
Hi,
I have a file using external formulas in the cells. i.e. =FM(XX, MM) gives a value using an external software's formula which is "FM". However, when my colleague uses the same file, he sees it as: =C:/ccc/ccc/FM(XX, MM) and needs to replace the C:/ccc/ccc part everytime. Is there a way to fix the FM formula so that another colleague in the network doesn't need to make such changes everytime? Regards, Hakan |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Fixing a link
I would use the same drive and folder on both pcs to hold that addin.
C:\HakansUtils\youraddin.xla You may have to clean up a few of your files to point at this location, but as soon as that housekeeping is done, you should be ok in the future. In fact, if it's possible, you could use a common network drive--either mapped to the same letter or using the UNC path. hakan wrote: Hi, I have a file using external formulas in the cells. i.e. =FM(XX, MM) gives a value using an external software's formula which is "FM". However, when my colleague uses the same file, he sees it as: =C:/ccc/ccc/FM(XX, MM) and needs to replace the C:/ccc/ccc part everytime. Is there a way to fix the FM formula so that another colleague in the network doesn't need to make such changes everytime? Regards, Hakan -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fixing the header on the top | Excel Discussion (Misc queries) | |||
Fixing Last Cell | Excel Discussion (Misc queries) | |||
Fixing some bugs | Excel Worksheet Functions | |||
Fixing Hyphens | Excel Worksheet Functions | |||
fixing problem with my tab | Excel Discussion (Misc queries) |