LoadBehavior changes from 3 to 2 in excel addin

Mohan Kumar Karunakaran

Hi,

I have created an Addin for Excel 2007 using VSTOSE and trying to deploy. I tried to deploy using the automatically
generated Setup project and everything works fine for the first instance. When I close the excel application and open again the Addin is loaded but doesn't show the custom ribbon.

When I checked "Office Button --> Excel Options --> Add-ins --> COM Add-ins --> MyExcelAddin" the addin is loaded but in unchecked state. I checked the registry and the Loadbehaviour is changed from initial 3 to 2.

(HKCU--S/w-->MS-->Office-->Excel --> Addins--> MyExcelAddin)

I have added setsecurity project mentioned in the walkthrough and added custom actions. Do I need to do anything more on this security options

I have downloaded and installed the fix also from the below mentioned location but of no use.

http://support.microsoft.com/kb/908002

Any help would be appreciated.

Thanks,

Mohan

Dennis Wallentin

Mohan,

Excel may have "blacklisted" the add-in due to an error (which has not necessarily generated any error message). So when you experience the issue again select the "Disabled items" instead of "COM Add-ins".

Mohan Kumar Karunakaran

Hi Dennis,

Thanks for your reply. I have checked "disabled items" but couldn't find my excel add-in. But the addin is residing in "Inactive Application Add-ins". Is there anyway to solve this problem so that the addin should be loaded at startup (Loaded but unchecked)

Thanks,

Mohan

Dennis Wallentin

Mohan,

I suspect it may be related to the CAS setting for the project - please see the answer to a similar question in the following thread: http://forums.microsoft.com/MSDN/ShowPost.aspx PostID=888712&SiteID=1

Mohan Kumar Karunakaran

Hi Dennis,

I have gone through the post you suggested and the problem I am facing is exactly the same one. But I could not find solution and I have no idea on how he fixed the problem.

I have added Security project to my addin and created custom actions as mentioned in the walkthrough. It sets CAS security for the installed addin. I have checked this in the below mentioned path.

Control Panel --> Administrative tools --> .Net Framework 2.0 Configuration --> My Computer --> Runtime Security Policy --> User --> MyName.MyExcelAddin --> MyExcelAddin. It has been set to FullTrust only.

I checked with Caspol.exe using the command Caspol -u -lg and it says the location is provided Full Trust.

I don't know how to proceed further.

I created another wordaddin and added the same security project and it works fine. Is there any workaround to fix this.

Thanks

Mohan

Dennis Wallentin

Mohan,

I don't know how to proceed further.

If You create a simple Excel project, apply the same CAS to it and then test it You can also send me a copy of the project if possible.

Mohan Kumar Karunakaran

Hi Dennis,

Can you provide me your mail id so that I can send the project copy.

Thanks

Dennis Wallentin

Mohan,

Put together the following:

dennis

_

wallentin

@

hotmail.com