excelinstallationadd-inexcel-dnaxll

Excel 64bit .xll add-in installation silently fails

I have simple add-in written in C# using Excel-DNA:

using ExcelDna.Integration;
using System;

namespace ExcelDNA_test {
    public class Functions {
        [ExcelFunction(Name = "CURRENTDATETIME")]
        public static DateTime CurrentDateTime() {
            return DateTime.Now;
        }

        [ExcelFunction(Name = "ADDTWONUMBERS")]
        public static int Add(int a, int b) {
            return a + b;
        }
    }
}

After building i get two files for add-in installation:

When i install x64 version on my laptop i can not see new category in add-in options. Also the name of add-in is not loaded properly (shows file name but not add-in name). There are no errors during installation.

I tried to install it on different machines:

Maybe there are no libraries installed on my PC for running this add-in?

Additional images:

Add-in name not loaded properly

Solution

  • Office 2013/2010

    Navigate to Control Panel -> Programs -> Uninstall a program -> Right click on Office -> Change.

    When dialog opened select Add or remove features. In Office Shared Features enable Visual Basic for Applications.

    Office Shared Features Dialog

    Office 2016/365

    In this releases Visual Basic for Applications installed by default. To install your .xll follow next steps:

    In office navigate to File -> Options -> Trust center -> Trust center settings.

    When dialog opened navigate to Macro settings. Select Enable all macros.

    Trust Center Settings Dialog

    If you upgraded from Office 2013 with installed Visual Basic for Applications component to Office 2016/365 this issue will not appear!