Excel-DNA / ExcelDna

Excel-DNA - Free and easy .NET for Excel. This repository contains the core Excel-DNA library.
https://excel-dna.net
zlib License
1.3k stars 276 forks source link

Excel Dna .xll addin is in inactive #349

Open sgompa opened 4 years ago

sgompa commented 4 years ago

Excel Dna .xll addin is creating dynamic com addin which is inactive when an excel setting "Requires Application addins to be signed with Trusted Publishers" in turned on. I have signed .xll with certificate and added certificate into Trusted Publishers.

govert commented 4 years ago

@sgompa I do expect it to work the way you explain, and remember testing this long ago. It's not so easy for me to go through this again now, but any additional information you can provide will help - Excel versions, Group Policy stuff etc. If you can help with some step-by-step write up of how to follow in your footsteps, I think that will help too. But the Office security settings can be a bit of a maze to understand.

sgompa commented 4 years ago

@govert - Thank you for quick response. I am using office 365 business 32 bit. Please find the attached screenshot of excel trust center settings. [image: image.png]

On Tue, Sep 15, 2020 at 5:47 PM Govert van Drimmelen < notifications@github.com> wrote:

@sgompa https://github.com/sgompa I do expect it to work the way you explain, and remember testing this long ago. It's not so easy for me to go through this again now, but any additional information you can provide will help - Excel versions, Group Policy stuff etc. If you can help with some step-by-step write up of how to follow in your footsteps, I think that will help too. But the Office security settings can be a bit of a maze to understand.

— You are receiving this because you were mentioned. Reply to this email directly, view it on GitHub https://github.com/Excel-DNA/ExcelDna/issues/349#issuecomment-692676738, or unsubscribe https://github.com/notifications/unsubscribe-auth/ADGFEFYRH4O5GJOWIPIIHWLSF5LN7ANCNFSM4RNA6RNA .

sgompa commented 4 years ago

screenshot2

sgompa commented 4 years ago

It is working in local environment with same setting. But not working in our customer environment