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.

About this Entry

This page contains a single entry by David Hyde published on July 13, 2015 3:51 PM.

Excel Add-in fix for Trusted Publisher setting was the previous entry in this blog.

Problem with Symantec Endpoint Protection 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