Add-In needs relinking?

Hello all. I've created an add-in that will be stored on a shared network drive for my co-workers to use. I'm running into a problem because every time I reopen a spreadsheet that uses a custom function in the add-in, excel says that it can't locate the function. I have to end up relinking to the .xla every time to get teh user-defined functions to work.

I think the problem is that the security settings in excel is set to medium. Is this true? To add to my frustration with this, our IT department won't let us lower our security settings to low. Is there something else that I can do fix this problem.

Thanks.

Hello Curare,

Interesting, choosing strychnos toxifera as a name. Sorry, I have had a long standing interest in horticulture. Depending on which version of Office you have, you might try digitally signing your Add-In. This system will then recognize your Add-In as safe.

Sincerely,
Leith Ross

Thanks for the responses. I've brought this issue up with my superiors and we will discuss what needs to be done at a higher level to see if we can request our IT department to provide us with a digital certificate. I'll let you know what end up deciding.

Thanks again!

Ok I tried the registering the functions per that article. That didn't work either. Excel keeps saying it can't find those functions even when I haven't moved the location of the add-in. Oh well, hoping IT will be able to help me out.