Fixing a link

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

hakan - 28 Apr 2008 14:44 GMT

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

Reply to this Message

Dave Peterson - 28 Apr 2008 15:16 GMT

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.

> Hi,
>
[quoted text clipped - 9 lines]
>
> Hakan

Signature

Dave Peterson

Reply to this Message