I have a MSExcel 2010 workbook which uses a User Defined Function via an Add-in (.xlam file). Although the add-in is saved on a network drive, when I try to load it into my add-in list using the browse in the Add-in Manager, it prompts to copy the add-in to the default path on my harddrive:
Whilst the add-in works perfectly if I'm using the workbook, if I want another person to use the workbook, they of course receive #NAME? errors for the formulae that use the UDF as the path name for the add-in is unique to my username In fact, the formulae get the explicit path name for the add-in added in front of the UDF. They have to load the add-in themselves and remove the old path name in the cells using a 'find/replace' in order to get the workbook to use the add-in. Likewise, once they've re-routed the pathname to their own harddrive, I have to re-route to mine if I want to use the workbook again.
Is there a way of directing the workbook to look in the network drive for the add-in rather than the user's personal harddrive?