Making the Excel add-ins work for a Sharepoint client Excel workbook
Hello
I have created a COM Interop managed UDF in the sharepoint server and deployed it as an add-in for the Excel workbook.The excel workbook is placed in a trusted file location and the UDF is registered as a trusted UDF with sharepoint.I have followed thehttp://blogs.msdn.com/cumgranosalis/archive/2006/08/03/ServerClientUDFsCompat1.aspx to create the UDF to support COM Interop and make it usable by the Excel as an Add-in.
When i open the sharepoint site from a different machine (not a sharepoint server machine),and open the excel workbook in edit mode , method calls in excel displays a #NAME error.This is because the add-in does not exist on the client machine.
Is it possible that i download or register the dll (UDF) when the excel is opened on the client machine?(similar to the situation where ActiveX objects are asked for download when we open a browser)
Can anybody help me with any alternate solutions for this problem?
