Disappearing Addins ribbon

What to do if the Addins ribbon does not appear?

What to do if Real Statistics disappears from the Addins ribbon?

Two hints were given in the Blogs of 7 August 2016 and 8 May 2015. These are repeated below. Keep in mind that even if the Addins ribbon does not appear or Real Statistics does not appear on the Addins ribbon, you can still access the Real Statistics data analysis tools by pressing Ctrl-m.

Hint 1:

  1. Press Alt-TI. On the dialog box that appears uncheck the Analysis ToolPak and ToolPak-VBA add-ins and click on the OK button.
  2. Close Excel and reopen Excel.
  3. Press Alt-TI. On the dialog box that appears check the Analysis ToolPak and ToolPak-VBA add-ins and click on the OK button.

This procedure assumes that you have previously installed RealStats (or RealStats-2007 if using Excel 2007). If not, then in step 1, prior to clicking on the OK button install Real Stats (and so RealStats and Solver should appear on the list of add-ins with a check mark next to them).

Hint 2:

This problem is likely due to a security enhancement that Microsoft recently made to Excel which impacts add-ins. The following steps should be useful in eliminating this problem.

  1. If Excel is running, close it
  2. Find the file with the Real Statistics add-in. Right click on the file and click on the Properties option from the menu that appears.
  3. Towards the bottom of the General tab of the Properties window you will see the security message “This file came from another computer and might be blocked to help protect this computer”. Next to this message is the Unblock check box. Make sure this is checked and press the OK button.
  4. Start Excel

If you don’t see the security message in step 3 above, then probably the cause of the problem is different.

 

 

8 Responses to Disappearing Addins ribbon

  1. Steve says:

    I had the same issues as Ian and his solution of making sure the file folder that contains the Real Stats file is listed among the user locations to be trusted. I had to add a new location, as Ian explained–seems to have worked for me as well.

  2. Ian says:

    Charles,

    Not sure whether this solution is stable, but RealStatistics now works when I designated the “Add-Ins” folder that you specify as a Trusted Location within Excel.
    Procedure is:
    1) Go to File; then Options; then Trust Center
    2) Go t Trust Center Settings and check whether the RealStats.xlam file folder (e.g., C:\Users\username\AppData\Roaming\Microsoft\AddIns) is listed among the user locations to be trusted. If not, go to Add New Location and paste it in.

    I’ll advise whether this is not a stable solution.

    Thanks for making this tool available and taking the care to support it. The functions are quite useful and a real contribution.

    Ian

  3. Ian says:

    Charles,

    See question above. Then, when I place the check mark next to Solver, Excel crashes and gives the following error message:
    “Excel is running into problems with the ‘solver add-in’ add-in. If this keeps happening, disable this add-in and check for available updates. Do you want to disable it now?”
    Choosing no results in a relaunch of Excel and crash.

  4. Ian says:

    Hi Charles,

    I’m having some difficulty getting the Jenks natural breaks function to run. I input the range of values, set the number of classes, leave the output range as default and get the following error message:
    “Compile error in hidden module: Cluster.
    This error commonly occurs when code is incompatible with the version, platform, or architecture of the application…”

    As far as I can tell, I’m running 32-bit RealStatistics on 32-bit Excel.
    Any suggestions welcome.

    Ian

    • Charles says:

      Ian,
      When you press Alt-TI do you see Solver on the list of addins with a check mark next to it?
      Which version of Excel are you running (2007, 2010, etc.)? What language (English, French, etc.) of Excel?
      Charles

      • Ian says:

        Charles,

        I’m running 32-bit Excel 2013, English version.

        I tried Alt-TI and found Solver was not checked. Then, when I place the check mark next to Solver, Excel crashes and gives the following error message:
        “Excel is running into problems with the ‘solver add-in’ add-in. If this keeps happening, disable this add-in and check for available updates. Do you want to disable it now?”
        Choosing no results in a relaunch of Excel and crash.

  5. John says:

    please Dr. i have successful installed the realstats in excel 2007 but when run analysis a dialog box appears indicate error hidden modules.please Dr i need your help. Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *