Disappearing Addins ribbon

What to do if the Addins ribbon does not appear?

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

When Real Statistics is used for the first time, the data analysis tools should be accessible from the Add-Ins ribbon. This support may disappear once Excel is closed.

You can use any one of the following three approaches to resolve this problem:

  • Press the key sequence Ctrl-Shft-m
  • Run the RSRibbonĀ macro. To do this press the Alt-F8 key sequence in Windows or Option-F8 on the Mac, enter the RSRibbon macro name (on the Macro dialog box) and press the Run button.
  • Press Ctrl-m and choose the Restore Real Statistics on Add-Ins Ribbon option

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.

See also

https://stackoverflow.com/questions/53649352/my-excel-add-in-keeps-disappearing-after-adding-it/63990268#63990268

36 thoughts on “Disappearing Addins ribbon”

  2. When following the advice here, after unblocking the file you may need to do the following:
    1. Press Alt-T-I to pull up the add-ins window
    2. Uncheck XRealStats (I also unchecked Solver to be sure)
    3. Press Ok
    4. Press Alt-T-I again and re-enable the add-ins.

    Once I did that the Add-ins ribbon appeared and everything worked.

    Reply

  3. Also observed that the extra prompt Screen on Excel Startup blocks this ribbon from running properly. Go to Excel Options >> General >> Startup options (very bottom) >> untick ‘Show the Start screen when this application starts’ and it should load fine.
    Can also control this via a reg key if you want too, by setting “DisableBootToOfficeStart”=dword:00000001

    Hope this helps – was annoying me for ages!

    Reply

  4. I’m in a Mac and I finally managed to get the add-ins tab to show, but when I click on it, is empty.
    This is what shows when I write =ver() –> 7.2 Excel 2016/2019/365 Mac
    I’ve followed every single step, installed, unistalled, and I’m about to throw the computer out the window because I dunno what to do or don’t do anymore.
    Please help!

    Reply

  5. Hi

    I am using excel 2019 version. I have installed the Resal Statistics Resource Pack and it worked for the first time but now I cannot execute it. It does not appear in the ribbon and Ctrl-m does not work (I only hear a bell). The Ctrl-shift-m does not work also

    Reply

  6. Hello Charles,
    Please how do I get the RealStatistics add-in. It seems I don’t have it in my excel add-ins. Thanks

    Reply

  7. Using Office Pro 13. Have Solver and Real Statistics working and placed in the file directory recommended. However, each time I save, close and then reopen a file, the ADD-INS is removed from the menu. When I select “Alt-T-I”, both Solver and Real Statistics is checked. I have to uncheck Real Statistics (which breaks all the cells with information). Then, I select “Alt-T-I” and recheck Real Statistics and all is restored.

    Is there a fix for this?

    Thanks,

    Steve

    Reply

      • Charles,

        Thanks for the quick reply. I had tried all three approaches, but none worked. When trying Ctrl-Shft-m, nothing happens. Same when trying Ctrl-m. The Alt-F8 key sequence only brings up a Windows Setting screen, but there is no Macro dialog box.

        When I open an Excel file that used the RealStats Logistic Regression, a message comes up stating “This workbook contains links to one or more external sources that could be unsafe”. The “Add-Ins” tab is not showing in the menu. When I select “Alt-t-i”, the Add-Ins box appears. Both Realstats and Solver Add-in are checked. However, I have to uncheck “Realstats” and select “OK”. I then have to repeat, check “Realstats”, OK and the “Add-Ins” tab (which has RealStat) appears. Not sure why the “Add-Ins” tab keeps disappearing after I close Excel.

        Reply

        • Hi Steve,
          The information I sent you in my previous response was for the Windows version of Excel.
          In any case, if Ctrl-m doesn’t work, then something is wrong since this should work for both Mac and Windows.
          The Alt-F8 key sequence is standard Excel and has nothing to do with Real Statistics. This should work in any Windows environment.
          Before proceeding further, let me first ask two questions: (1) are you using a Mac? (2) What do you see when you enter the formula =VER() in any cell on a spreadsheet?
          Charles

          Reply

  9. Charles,

    Iā€™m running 64-bit Excel 2016. I try Alt+TI, only the realstats is checked, Solver is not on the list. How can I add the Solver into the list?

    Reply

  10. 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.

    Reply

  11. 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

    Reply

  12. 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.

    Reply

  13. 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

    Reply

    • 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

      Reply

      • 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.

        Reply

  14. 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

    Reply

Leave a Comment