none
load behaviour value changes from 3 to 0 when excel loads RRS feed

  • Question

  • Hi,

    We have recently reinstalled MS office 2007 service pack 2 after which the COM add-in also reinstalled. The problem is that after the re installation of add-in it is not visible in excel. I have checked the various options and applied the EnableVSTO reg key to 1 as well. But still it is not visible in excel.  When the excel opens it is resetting the load behaviour to 0 from 3 under HKEY local machine. We are working on windows 2003 terminal server. Manually we tried to enable the add-in by going through the excel options, tried to enable the alerts for VSTO but not getting any alerts as well.

    Can anyone help on this issue?

    Thanks

    venkat


    Thursday, May 29, 2014 11:42 AM

Answers

  • Hello,

    Did you have a chance to check out the Trust center setting?

    Also Microsoft Office applications can disable add-ins that behave unexpectedly. If an application does not load your add-in, the application might have hard disabled or soft disabled your add-in.

    Hard disabling can occur when an add-in causes the application to close unexpectedly. It might also occur on your development computer if you stop the debugger while the Startup event handler in your add-in is executing.

    Soft disabling can occur when an add-in produces an error that does not cause the application to unexpectedly close. For example, an application might soft disable an add-in if it throws an unhandled exception while the Startup event handler is executing.

    When you re-enable a soft-disabled add-in, the application immediately attempts to load the add-in. If the problem that initially caused the application to soft disable the add-in has not been fixed, the application will soft disable the add-in again.

    You can read more about this in the How to: Re-enable an Add-in That Has Been Disabled article in MSDN.

    Thursday, May 29, 2014 5:57 PM

All replies

  • Hello,

    Did you have a chance to check out the Trust center setting?

    Also Microsoft Office applications can disable add-ins that behave unexpectedly. If an application does not load your add-in, the application might have hard disabled or soft disabled your add-in.

    Hard disabling can occur when an add-in causes the application to close unexpectedly. It might also occur on your development computer if you stop the debugger while the Startup event handler in your add-in is executing.

    Soft disabling can occur when an add-in produces an error that does not cause the application to unexpectedly close. For example, an application might soft disable an add-in if it throws an unhandled exception while the Startup event handler is executing.

    When you re-enable a soft-disabled add-in, the application immediately attempts to load the add-in. If the problem that initially caused the application to soft disable the add-in has not been fixed, the application will soft disable the add-in again.

    You can read more about this in the How to: Re-enable an Add-in That Has Been Disabled article in MSDN.

    Thursday, May 29, 2014 5:57 PM
  • Hi,

    Thanks for the post. The issue is resolved by installing the security patches which are related to MS office as the patches were uninstalled while the MS office was uninstalled. Thank you for your help.

    Thanks 

    venkat.


    Regards Venkat

    Tuesday, June 10, 2014 10:17 AM