July 2015 Archives

Excel 2013 problem solved

Along with the previous blog entry on Trusted Publisher settings, there is a change in Excel 2013 related to the ribbon which might prevent the DPlot Add-in from showing correctly. Fortunately there is an easy fix..

If you are running Excel 2013 and the DPlot Add-in does not show up and you have any other add-ins loaded (in particular either of the Analysis ToolPak add-ins):

  1. Select File>Options>Add-ins.
  2. Ensure that the "Manage" selection is "Excel Add-Ins" then click "Go"
  3. Uncheck the boxes next to any add-in other than "DPlot interface". (In my experience the Analysis ToolPak add-ins are the culprits, but there may be others and in any case you're going to reload everything to finish this up, so there is no harm in unloading add-ins.)
  4. Click OK, exit and restart Excel.
  5. Most likely the DPlot Add-in will now show up on the ribbon. In any case, reload the add-ins you were previously using, if desired:
  6. Select File>Options>Add-ins. Again click the Go button. Check the boxes for the add-ins you want to load.
I'm not entirely certain why this works, but it has something to do with a change in behavior of the ribbon in Excel 2013: each open document gets its own unique ribbon. (In 2007 and 2010 versions there was only one ribbon.) Apparently (?) the Analysis ToolPak does something to the default ribbon to prevent additions. Loading the DPlot Add-in first gets around this behavior. Hopefully a future version of the Add-in will add code so that this hoop-jumping is no longer necessary.

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 Archive

This page is an archive of entries from July 2015 listed from newest to oldest.

March 2014 is the previous archive.

September 2016 is the next archive.

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



Powered by Movable Type 4.25