Save an Excel Add-in to a network drive

5 pts.
Tags:
Excel Add-in
Microsoft Excel 2010
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:

C:UsersusernameAppDataRoamingMicrosoftAddIns

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?

Hope all this makes sense!

 



Software/Hardware used:
MSExcel 2010; Windows 7
ASKED: March 14, 2012  11:52 PM
UPDATED: March 15, 2012  12:25 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following