Why am I getting "Unable to find manifest signing certificate in the certificate store" in my Excel Addin?

Visual StudioVstoExcel 2007

Visual Studio Problem Overview


I've got an Excel add-in project that was created a couple years back in Visual Studio 2008. It's got some changes to be made so I've upgraded to Visual Studio 2010 (the only IDE I am able to use). Not sure if this is causing the problem but it's background information.

When I check out the code and compile it I get the error, "Error 1 Unable to find manifest signing certificate in the certificate store."

Can anyone tell me what this means and how to fix it?

Visual Studio Solutions


Solution 1 - Visual Studio

You need to re-add that certificate to your machine or chose another certificate.

To choose another certificate or to recreate one, head over to the Project's properties page, click on Signing tab and either

  • Click on Select from store
  • Click on Select from file
  • Click on Create test certificate

Once either of these is done, you should be able to build it again.

Solution 2 - Visual Studio

I found this solution which solved the problem for me: Removing all entries in your *.csproj that fall into:

<manifestcertificatethumbprint>...</manifestcertificatethumbprint>
<manifestkeyfile>...</manifestkeyfile>
<generatemanifests>...</generatemanifests>
<signmanifests>...</signmanifests>

Solution 3 - Visual Studio

A quick solution to get me going was to uncheck the "Sign the ClickOnce manifests" in: Project -> (project name)Properties -> Signing Tab

Solution 4 - Visual Studio

When the project was originally created, the click-once signing certificate was added on the signing tab of the project's properties. This signs the click-once manifest when you build it. Between then and now, that certificate is no longer available. Either this wasn't the machine you originally built it on or it got cleaned up somehow. You need to re-add that certificate to your machine or chose another certificate.

Solution 5 - Visual Studio

Adding new certificate resolved this issue for me. Properties page -> signing -> Click on Create test certificate

Solution 6 - Visual Studio

Make sure you commit .pfx files to repository.

I just found *.pfx in my default .gitignore. Comment it (by #) and commit changes. Then pull repository and rebuild.

Solution 7 - Visual Studio

  1. Delete these entries mentioned in this post: http://manfredlange.blogspot.ca/2008/03/visual-studio-unable-to-find-manifest.html.

  2. Also remove the .snk or .pfx files from the project root.

Don't forget to push these changes to GitHub, for Jenkins only pulls source from GitHub.

Solution 8 - Visual Studio

The issue of erroneous leftover entries in the .csproj file still occurs with VS2015update3 and can also occur if you try to change the signing certificate for a different one (even if that is one generated using the 'new' option in the certificate selection dropdown). The advice in the accepted answer (mark as not signed, save, unload project, edit .csproj, remove the properties relating to the old certificates/thumbprints/keys & reload project, set certificate) is reliable.

Solution 9 - Visual Studio

I create a new key, I had to search the csproj for the old one and refactor it.

Attributions

All content for this solution is sourced from the original question on Stackoverflow.

The content on this page is licensed under the Attribution-ShareAlike 4.0 International (CC BY-SA 4.0) license.

Content TypeOriginal AuthorOriginal Content on Stackoverflow
QuestionAndy ParsonsView Question on Stackoverflow
Solution 1 - Visual StudioSathyajith BhatView Answer on Stackoverflow
Solution 2 - Visual StudioWernightView Answer on Stackoverflow
Solution 3 - Visual StudioRudyView Answer on Stackoverflow
Solution 4 - Visual StudioGardnerView Answer on Stackoverflow
Solution 5 - Visual StudiomoglimcgrathView Answer on Stackoverflow
Solution 6 - Visual StudioApceH HypocriteView Answer on Stackoverflow
Solution 7 - Visual StudioJirong HuView Answer on Stackoverflow
Solution 8 - Visual Studiosimon colemanView Answer on Stackoverflow
Solution 9 - Visual StudioBilly Jake O'ConnorView Answer on Stackoverflow