AddIn not working right

Here's the problem:
I am running Excel 2000
I created an addin file to avoid the "... contains macros" pop up. The addin contains a custom function.
This is where it gets tricky - I share this workbook by placing it on a drive on the company's intranet.
The formula changes from calling the function from the addin when it is saved to the C: drive to a complicated link with the address from my C: drive with the drive letter changed to the intranet drive letter.
From: =Alarm.xla!AVGAlarm(AA6:AA36,">225860",AA37)
To: ='R:\Documents and Settings\kowalsd\Application Data\Microsoft\AddIns\Alarm.xla'!AVGAlarm(AA6:AA36,">225860",AA37)