Excel Add-in fix for Trusted Publisher setting

I've had several e-mails about the Add-In not appearing in Excel 2013 lately. Curiously not so much for Excel 2010, for which this should also be a problem with similar "Trust Center" settings. In any case, the problem was due to using a personal code-signing certificate for the Add-In rather than one of the... holding my tongue... somewhat more expensive code-signing certificates from MS-approved certificate authorities. Unfortunately getting the problem fixed will require some hoop-jumping on your part if you're having this problem.

  1. Start Excel. Go to File>Options>Add-ins, click Go next to "Manage Add-ins", uncheck "DPlot interface", click OK.
  2. Go to File>Options>Trust Center, click the "Trust Center Settings" button. In the left pane select "Message Bar". Ensure that "Show the Message Bar in all applications when active content, such as ActiveX controls and macros, has been blocked" is selected. Click OK twice and exit Excel.
  3. Download and save the updated Add-In to %appdata%\Microsoft\Addins, overwriting the existing version.
  4. Start Excel. You'll almost certainly see a security warning. If so, click on "Some active content has been disabled. Click for more details."
  5. Click "Enable Content", then "Advanced Options".
  6. You may see more than one "untrusted" offender. Look for "Signed by: HydeSoft Computing LLC". This may not be the first entry and you'll need to scroll through the list. Select "Trust all documents from this publisher" then click OK.
  7. Exit and restart Excel. 
You should now see an Add-ins tab and when clicked see the DPlot Add-in just below the File tab. If not please let me know at support@dplot.com.

About this Entry

This page contains a single entry by David Hyde published on July 8, 2015 11:11 PM.

Macro examples for simple tasks was the previous entry in this blog.

Excel 2013 problem solved is the next entry in this blog.

Find recent content on the main index or look in the archives to find all content.

Categories

Pages

Powered by Movable Type 4.25