Fixing a link

[hakan]

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]

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.