Add-in Menu has Disappeared from the Ribbon Bar 2017-08-16T12:47:12+00:00

Add-in Menu has Disappeared from the Excel Ribbon Bar

Everything on the internet today is so automatic, people sometimes forget that there is a lot of work going on behind the scenes. When you ask for a download, sometimes it takes gigabytes of data to produce that spreadsheet you’re waiting for. That’s the equivalent of at least one high def movie!  While the download is happening, sometimes they think that Excel is frozen, so they shut Excel down or turn off their computer. At that point, Excel puts the Addin in a Disabled state and that must be reversed.

This set of instructions will help you if the NEXT Analytics software has been disabled, most usually seen when the tab on the Windows Excel Ribbon bar is missing.

next-analytics-excel-ribbon-bar

First, try rebooting your computer to see if it comes back. Excel processes sometimes get ‘stuck’ in memory, preventing the proper start-up of any add-ins.

There are times when Excel does not close properly such as when you shutdown with a file open. It may disable any installed add-ins that are running at that time, and the effect is that the Next Analytics menu item will disappear. It could be “hard-disabled” or “soft-disabled”, so you have to check both possibilities.

Step 1 – verify that the add-in has not been moved to Disabled Items.

excel-add-in-disabled-by-excel

Step 2 – make sure the add-in is checked in COM Add-ins

excel-add-in-unloaded-by-excel


[Excel 2013 / Excel 2016]

  • Click the File menu

1-click-file

  • Select Options

2-click-options

  • Select Add-ins on the left side menu
  • In the drop-down at the bottom, Manage: Disabled items, and click the Go… button

3-select-addins

  • NextanalyticsForExcel should be NOT listed. If it is, select it and click Enable.

excel-add-in-disabled-by-excel

  • Click the File menu, select Options, Select Add-ins
  • In the drop-down at the bottom, Manage: Com Add-ins, and click the Go… button

4-select-com-addins

  • NextanalyticsForExcel should be listed and it needs to be checked. Click OK when you are done.

excel-add-in-unloaded-by-excel

[Excel 2010]

  • Click the File menu, select Options- select Add-ins
  • in the drop-down at the bottom, Manage: Disabled items, and click the Go… button
  • NextanalyticsForExcel should be NOT listed. If it is, select it and click Enable.
  • Click the File menu, select Options
  • select Add-ins
  • in the drop-down at the bottom, Manage: Com Add-ins, and click the Go… button
  • NextanalyticsForExcel should be listed and it needs to be checked. Click OK when you are done.

[Excel 2007]

  • Click the Excel/Office button (upper left round button), select Excel options
  • Click the File menu, select Options – select Add-ins
  • In the drop-down at the bottom, Manage: Disabled items, and click the Go… button
  • NextanalyticsForExcel should be NOT listed. If it is, select it and click Enable.
  • Click the Excel/Office button (upper left round button), select Excel options
  • Select Add-ins
  • in the drop-down at the bottom, Manage: Com Add-ins, and click the Go… button
  • NextanalyticsForExcel should be listed and it needs to be checked. Click OK when you are done.