none
Excel Addin not loading RRS feed

  • Question

  • I deployed an Excel addin using ClickOnce.  I added the required prerequisites Microsoft .NET Framework 4.7.2 and Microsoft Visual Studio 2010 Tools for Office Runtime.

    It used to work properly, but since a couple of days now, new users that install the addin get a successfull installation but it is always disabled.  The addin is still working properly for people that installed it a couple of weeks ago.  It is just not working for new users.

    To troubleshoot this issue I tried the following steps on a workstation where the addin is not working:

    - Verify if the addin is part of the add/remove programs list.  It is there.

    - Verify if the addin is part of the COM Add-ins list under File > Options > Add-ins.  It is there but, but never checked.  Checking it does nothing.  After going back to the list, the addin is always unchecked.   The Visual Studio Tools for Office Adaptor for Excel is missing.  It is there in the workstations where the addin functions normally.

    - Find its registry key to look at the state of the LoadBehavior variable for the addin.  There is no registry key for the addin under HKEY_CURRENT_USER > Software > Microsoft > Office > Excel > Addins.

    - Check to see if the addin had been hard-disabled by Excel.  The addin is in the "Inactive Application Add-ins" group not the "Disabled Applications Add-ins".

    - Manually install the VSTO Tools for Office (vstor_redist.exe) and check if the VSTO Adaptor for Excel is available in the COM Add-ins.  The VSTO Adaptor for Excel is still missing.

    - Check if the VSTO Adaptor for Excel is part of the Automation list of addins.  It is not there.

    Set the "VSTO_SUPPRESSDISPLAYALERTS" environment variable to 0, and try to load the addin to see if a dialog box would show up.  Nothing happened.

    I found all these troubleshooting steps in existing help threads about VSTO addins not loading.  My situation seems different then what I am able to find and I cannot resolve this issue.  Please help.

    Wednesday, January 16, 2019 9:46 PM

All replies

  • Hi Olivier,

    Welcome to the MSDN forum.

    Refer to the description, this issue is about the ClickOnce development and our forum is to discuss the VS IDE, I will help you move this thread to the appropriate forum for a better support, thank you for your understanding.

    Best regards,

    Sara


    MSDN Community Support Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com

    Thursday, January 17, 2019 3:26 AM
  • Hi Olivier,

    According to your description, the issue is much more related to VSTO. It will be more appropriate to ask your question at Visual Studio Tools for Office (VSTO).

    Thank you for your understanding.

    Regards,

    Kyle


    MSDN Community Support
    Please remember to click "Mark as Answer" the responses that resolved your issue, and to click "Unmark as Answer" if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact MSDNFSF@microsoft.com.

    Thursday, January 17, 2019 9:39 AM