Mixing
Excel 64bit .xll add-in installation silently fails
.everyoneloves__top-leaderboard:empty,.everyoneloves__mid-leaderboard:empty,.everyoneloves__bot-mid-leaderboard:empty{ height:90px;width:728px;box-sizing:border-box;
}
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:
- ExcelDNA_test-AddIn-packed.xll
- ExcelDNA_test-AddIn64-packed.xll
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:
- Windows 10 x64, Excel 365 x64 - fail.
- Windows 10 x64, Excel 365 x64 - fail.
- Windows 10 x64, Excel 365 x64 - works.
- Windows 10 x64, Excel 365/2013 x64 - works.
- Windows 10 x64, Excel 2013 x64 - fails (my case).
Maybe there are no libraries installed on my PC for running this add-in?
Additional images:
excel installation add-in excel-dna xll
edited Jan 4 at 23:23
Stein Åsmul
23k1458123
asked Jan 3 at 8:09
KikoKiko
1312
add a comment |
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:
- ExcelDNA_test-AddIn-packed.xll
- ExcelDNA_test-AddIn64-packed.xll
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:
- Windows 10 x64, Excel 365 x64 - fail.
- Windows 10 x64, Excel 365 x64 - fail.
- Windows 10 x64, Excel 365 x64 - works.
- Windows 10 x64, Excel 365/2013 x64 - works.
- Windows 10 x64, Excel 2013 x64 - fails (my case).
Maybe there are no libraries installed on my PC for running this add-in?
Additional images:
excel installation add-in excel-dna xll
edited Jan 4 at 23:23
Stein Åsmul
23k1458123
asked Jan 3 at 8:09
KikoKiko
1312
Do you have any antivirus running on the machine? If you're running on a corporate environment, you might have a security app blocking the add-in from being loaded
– Caio Proiete
Jan 3 at 14:37
add a comment |
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:
- ExcelDNA_test-AddIn-packed.xll
- ExcelDNA_test-AddIn64-packed.xll
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:
- Windows 10 x64, Excel 365 x64 - fail.
- Windows 10 x64, Excel 365 x64 - fail.
- Windows 10 x64, Excel 365 x64 - works.
- Windows 10 x64, Excel 365/2013 x64 - works.
- Windows 10 x64, Excel 2013 x64 - fails (my case).
Maybe there are no libraries installed on my PC for running this add-in?
Additional images:
excel installation add-in excel-dna xll
edited Jan 4 at 23:23
Stein Åsmul
23k1458123
asked Jan 3 at 8:09
KikoKiko
1312
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:
- ExcelDNA_test-AddIn-packed.xll
- ExcelDNA_test-AddIn64-packed.xll
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:
- Windows 10 x64, Excel 365 x64 - fail.
- Windows 10 x64, Excel 365 x64 - fail.
- Windows 10 x64, Excel 365 x64 - works.
- Windows 10 x64, Excel 365/2013 x64 - works.
- Windows 10 x64, Excel 2013 x64 - fails (my case).
Maybe there are no libraries installed on my PC for running this add-in?
Additional images:
excel installation add-in excel-dna xll
excel installation add-in excel-dna xll
edited Jan 4 at 23:23
Stein Åsmul
23k1458123
asked Jan 3 at 8:09
KikoKiko
1312
edited Jan 4 at 23:23
Stein Åsmul
23k1458123
asked Jan 3 at 8:09
KikoKiko
1312
edited Jan 4 at 23:23
Stein Åsmul
23k1458123
edited Jan 4 at 23:23
Stein Åsmul
23k1458123
edited Jan 4 at 23:23
Stein Åsmul
23k1458123
23k1458123
asked Jan 3 at 8:09
KikoKiko
1312
asked Jan 3 at 8:09
KikoKiko
1312
asked Jan 3 at 8:09
KikoKiko
1312
1312
Do you have any antivirus running on the machine? If you're running on a corporate environment, you might have a security app blocking the add-in from being loaded
– Caio Proiete
Jan 3 at 14:37
add a comment |
Do you have any antivirus running on the machine? If you're running on a corporate environment, you might have a security app blocking the add-in from being loaded
– Caio Proiete
Jan 3 at 14:37
Do you have any antivirus running on the machine? If you're running on a corporate environment, you might have a security app blocking the add-in from being loaded
– Caio Proiete
Jan 3 at 14:37
Do you have any antivirus running on the machine? If you're running on a corporate environment, you might have a security app blocking the add-in from being loaded
– Caio Proiete
Jan 3 at 14:37
add a comment |
2 Answers
2
active
oldest
votes
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 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.
If you upgraded from Office 2013 with installed Visual Basic for Applications component to Office 2016/365 this issue will not appear!
edited Jan 5 at 16:08
Caio Proiete
6,3032037
answered Jan 4 at 21:04
KikoKiko
1312
add a comment |
Do you have any antivirus running on the machine? If you're running on a corporate environment, you might have a security app blocking the add-in from being loaded.
You might also want to try to add the folder where your .xll file is, to the Trusted Locations of Excel:
answered Jan 3 at 14:41
Caio ProieteCaio Proiete
6,3032037
Thanks for your answer. Windows Defender installed on all machines as antivirus. I don't use corporate environment. I tried specified setting. Add-in successfully installed from all folders on other machine.
– Kiko
Jan 3 at 15:21
Also i want to add that i have 2 x64 add-ins and both of them don't run on my PC but on other do.
– Kiko
Jan 3 at 15:56
add a comment |
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54018486%2fexcel-64bit-xll-add-in-installation-silently-fails%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
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 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.
If you upgraded from Office 2013 with installed Visual Basic for Applications component to Office 2016/365 this issue will not appear!
edited Jan 5 at 16:08
Caio Proiete
6,3032037
answered Jan 4 at 21:04
KikoKiko
1312
add a comment |
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 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.
If you upgraded from Office 2013 with installed Visual Basic for Applications component to Office 2016/365 this issue will not appear!
edited Jan 5 at 16:08
Caio Proiete
6,3032037
answered Jan 4 at 21:04
KikoKiko
1312
add a comment |
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 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.
If you upgraded from Office 2013 with installed Visual Basic for Applications component to Office 2016/365 this issue will not appear!
edited Jan 5 at 16:08
Caio Proiete
6,3032037
answered Jan 4 at 21:04
KikoKiko
1312
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 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.
If you upgraded from Office 2013 with installed Visual Basic for Applications component to Office 2016/365 this issue will not appear!
edited Jan 5 at 16:08
Caio Proiete
6,3032037
answered Jan 4 at 21:04
KikoKiko
1312
edited Jan 5 at 16:08
Caio Proiete
6,3032037
edited Jan 5 at 16:08
Caio Proiete
6,3032037
edited Jan 5 at 16:08
Caio Proiete
6,3032037
6,3032037
answered Jan 4 at 21:04
KikoKiko
1312
answered Jan 4 at 21:04
KikoKiko
1312
answered Jan 4 at 21:04
KikoKiko
1312
1312
add a comment |
add a comment |
Do you have any antivirus running on the machine? If you're running on a corporate environment, you might have a security app blocking the add-in from being loaded.
You might also want to try to add the folder where your .xll file is, to the Trusted Locations of Excel:
answered Jan 3 at 14:41
Caio ProieteCaio Proiete
6,3032037
Thanks for your answer. Windows Defender installed on all machines as antivirus. I don't use corporate environment. I tried specified setting. Add-in successfully installed from all folders on other machine.
– Kiko
Jan 3 at 15:21
Also i want to add that i have 2 x64 add-ins and both of them don't run on my PC but on other do.
– Kiko
Jan 3 at 15:56
add a comment |
Do you have any antivirus running on the machine? If you're running on a corporate environment, you might have a security app blocking the add-in from being loaded.
You might also want to try to add the folder where your .xll file is, to the Trusted Locations of Excel:
answered Jan 3 at 14:41
Caio ProieteCaio Proiete
6,3032037
Thanks for your answer. Windows Defender installed on all machines as antivirus. I don't use corporate environment. I tried specified setting. Add-in successfully installed from all folders on other machine.
– Kiko
Jan 3 at 15:21
Also i want to add that i have 2 x64 add-ins and both of them don't run on my PC but on other do.
– Kiko
Jan 3 at 15:56
add a comment |
Do you have any antivirus running on the machine? If you're running on a corporate environment, you might have a security app blocking the add-in from being loaded.
You might also want to try to add the folder where your .xll file is, to the Trusted Locations of Excel:
answered Jan 3 at 14:41
Caio ProieteCaio Proiete
6,3032037
Do you have any antivirus running on the machine? If you're running on a corporate environment, you might have a security app blocking the add-in from being loaded.
You might also want to try to add the folder where your .xll file is, to the Trusted Locations of Excel:
answered Jan 3 at 14:41
Caio ProieteCaio Proiete
6,3032037
answered Jan 3 at 14:41
Caio ProieteCaio Proiete
6,3032037
answered Jan 3 at 14:41
Caio ProieteCaio Proiete
6,3032037
answered Jan 3 at 14:41
Caio ProieteCaio Proiete
6,3032037
6,3032037
Thanks for your answer. Windows Defender installed on all machines as antivirus. I don't use corporate environment. I tried specified setting. Add-in successfully installed from all folders on other machine.
– Kiko
Jan 3 at 15:21
Also i want to add that i have 2 x64 add-ins and both of them don't run on my PC but on other do.
– Kiko
Jan 3 at 15:56
add a comment |
Thanks for your answer. Windows Defender installed on all machines as antivirus. I don't use corporate environment. I tried specified setting. Add-in successfully installed from all folders on other machine.
– Kiko
Jan 3 at 15:21
Also i want to add that i have 2 x64 add-ins and both of them don't run on my PC but on other do.
– Kiko
Jan 3 at 15:56
Thanks for your answer. Windows Defender installed on all machines as antivirus. I don't use corporate environment. I tried specified setting. Add-in successfully installed from all folders on other machine.
– Kiko
Jan 3 at 15:21
Thanks for your answer. Windows Defender installed on all machines as antivirus. I don't use corporate environment. I tried specified setting. Add-in successfully installed from all folders on other machine.
– Kiko
Jan 3 at 15:21
Also i want to add that i have 2 x64 add-ins and both of them don't run on my PC but on other do.
– Kiko
Jan 3 at 15:56
Also i want to add that i have 2 x64 add-ins and both of them don't run on my PC but on other do.
– Kiko
Jan 3 at 15:56
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f54018486%2fexcel-64bit-xll-add-in-installation-silently-fails%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Do you have any antivirus running on the machine? If you're running on a corporate environment, you might have a security app blocking the add-in from being loaded
– Caio Proiete
Jan 3 at 14:37