How to prevent links to ouside sources?
 

Hi,

This is loosely related to my other posts over the past couple of weeks.
This seems like it would be an FAQ, but apparently it is not.

I have created a VBA add-in (used by several of my colleagues) which
provides a function "giveMeSomeValue()". If my colleague creates a worksheet
which uses this function "=10*giveMeSomeValue()", saves it on a common
drive, and then I open it, the formula becomes

=10*'C:\Path\ReminiscentOf\WhereHeKeeps\MyAddin.xl a'!giveMeSomeValue()

Of course, I have the same add-in installed (in a different place,
typically) so everything would work for me if the original formula remained
intact, and it doesn't in its new form. How do I make it remain in its
original form then?

Many thanks in advance!

Bura