Password Prompt

You never need to supply a password to use the Real Statistics Resource Pack.

The usual reason for receiving this message is that the software has been downloaded but not installed. If the software is installed correctly, then when you press Alt-TI you should see RealStats and Solver on the list of add-ins with a check mark next to each of them.

If not, you need to follow the installation instructions which can be found on the same webpage from where you downloaded the file containing the software.

If there is a problem during the installation try one or more of the following (in the Windows environment):

  1. If Excel is running, close it. 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. 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. Start Excel.
  2. Click on Options from the File ribbon and then choose the Trust Center option on the left side. Next click on Trust Center Settings …. Next click on the Macro Settings option on the left side and make sure that it is Disable all Macros with Notification. Also click on the Trusted Locations option on the left side and click on the Add New Location… button to add the folder that contains RealStats folder as a trusted location.
  3. Try opening a blank Excel worksheet and press Alt-TI. Uncheck the RealStats addin and close Excel. Now open a blank Excel worksheet and press Alt-TI. This time check the RealStats addin

Most important, remember that Solver must be installed. To check this, press Alt-TI and make sure that Solver (as well as RealStats) is on the list of addins with a check mark next to it.

65 thoughts on “Password Prompt”

  1. I fillowed all the steps properly.
    But I’m getting this message when i check the real stats after pressing Alt TI
    “Can’t find project or library” from Microsoft Visual Basic for application

    Though Add in tab appears with real stats
    I try to operate but it again shows the same compiling error

    “ Compile error in hidden module: Analysis. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application.”

    Please help me solve this issue.

    Reply

    • What do you see when you enter the formula =VER() in any cell?
      Have you tried to use any of the approaches described in the Troubleshooting section of the webpage from where you downloaded the software?
      Charles

      Reply

  2. Dear Charles, when i tried to open the VBA file XRealStats as a developer i get the password prompt.
    I’d like to make some changes but i am apparently not allowed.
    The standard works and i get the prompt and I can do the presented default statistics.
    But not all I want is in there. I want to add a few I need.
    You site shows that you do have them, with your own developed not standard Excel statements.
    Is there a way to change your standard options in my standard options and if so, how.
    Thanks a lot, stay safe and healthy

    Reply

  3. I am initially very impressed with your add-in. However, I am having problem with the installation.
    Environment
    • I have installed RealStats in C:\Users\XXX\AppData\Roaming\Microsoft\AddIns
    • I have added this location into Trusted sites and Macro settings are as advised “Disable all macros with notification”
    • I am running Microsoft Excel for Windows 365 MSO (16.0.12624.20424) 64 bit
    • I am operating under Windows 10 on a Microsoft Surface 7
    • Solver is active
    In Trust Centre add-in I activated RealStats and it works just fine.
    Next time I start Excel during the start up I can see RealStats opening in the initial Excel green startup panel then the Excel start up stops
    If I try starting up Excel again, I get the message

    Excel is running into problems with the ‘c:\program files\microsoft office\root\office16\solver\solver.xlam’ add-in. If this keeps happening, disable this add-in and check for available updates. Do you want to disable it now?

    If I disable Solver, I can open Excel. RealStats is still installed (=VER() returns 5.11 Excel 2007) but the add-in is not visible on the ribbon. Under Options-> add-in RealStats is checked but as expected Solver is not. If I check Solver, I get an error message.
    If I uncheck RealStats, I get the message “Can’t find project or Library”, If I click OK then I get asked for a password. I “Cancel”. At this stage in the Add-in menu, neither RealStats nor Solver is active.

    I can now activate Solver and RealStats and everything is functional. However, If I save the file, and exit, then the whole problem starts all over again on re-starting Excel

    Any Ideas please?

    Thanks Allan

    Reply

  4. I have tried to click on Trusted Locations option on the left side and click on the Add New Location… button to add the folder that contains RealStats folder as a trusted location, but The file of realstatistic does not appear.

    Reply

  5. Dear Charles,

    I have downloaded the RealStats-Mac-2011.xlam and I have followed your instructions. I have also uninstalled and re-installed several times and also read comments from other readers.

    I always get the”Can’t find project or library” and when I press ok I get the password window.
    If I enter =VER() in any cell I get “5.11 Excel Mac 2011”
    Solver is checked under Add-Ins

    I have the “Real Statistics” visible in the menu bar and it works when I press “Data Analysis Tools”, but when I try to use Multinomial Logistic Regression and enter all values I get “Compile Error in Hidden module: Address”

    Any idea how to solve this?

    Best regards,
    Daniel

    Reply

  6. Hi, im trying to get the realstats package to work on my mac excel 5.11 Excel Mac 2011.
    It doesnt work and says “compile error” everytime i try to use it. I have tried following all the things on this site and read various threads here. Nothing seems to work. Yes the solver check box is ticked all the time and i have followed the installation instructions properly. I have also tried doing it in a new blacnk workbook and it still does not work.
    any ideas?

    Reply

  8. Why do so many of the chains, that I too am having a similar issue, never have resolutions? Why haven’t Tushar or Deb reported back?

    This shouldn’t be this frustrating.

    Reply

  9. Hi,
    I’ve used the add in few weeks ago and everything worked fine. Today when I opened the excel, the add in was not shown in the ribbon. I’ve tried reinstall the old version and it didn’t help. then I’ve downloaded the newest one and did everything according to instructions, but it did not work (requires password). I went through all steps on this page and the situation hasn’t changed..

    Reply

  10. Hi Charles,
    I’m trying to use RealStats, but I keep getting the “password required” error. I followed all of the steps with trusting the RealStats file, etc., but whenever I bring up the add-ins menu via Alt-TI, the RealStats and Solver AddIns boxes are both unchecked. If I check both and click OK, Excel freezes, then returns “Can’t find project or library.” Clicking through on that prompt brings up the RealStats password box, and of course clicking “cancel” on that returns me back to the blank workbook. Entering =VER() brings up the file path, 6.0.4 Excel/…/Office 365. Please advise. Thank you!

    Reply

    • Hello Anna,
      I don’t know why you would be having these problems. I do see that you aren’t using the latest version of the Real Statistics software, namely Rel 6.1 (instead of Rel 6.0.4). I suggest that you download the latest version and try again.
      Charles

      Reply

        • Hi Vini,
          Are you having the same problems as Anna?
          Have you looked at the Troubleshooting instructions on the webpage from which you downloaed the Real Statistics software?
          Having installed an earlier version of the Real Statistics software sometime in the past?
          When you press Alt-TI do you see Solver on the list of add-ins with a check mark next to it?
          Do you see Rel 6.1 when you enter the formula =VER() in any cell?

          Reply

  11. Hi Charles
    I’m very keen to use your system however I continually get Mac installation problems.
    I have Excel 2011 v14. When I try to install the Add Ins it returns a message saying
    “Can’t find project or libarary”. “OK.”
    I click OK and then get asked for a password.
    If I OK with a blank password it responds with a warning the “Project is Locked” and returns to password field.
    If I click CANCEL then Real Stats is installed, including the RealStats Menu
    HOWEVER
    When trying to then open the example files I get repeated messages
    “Compile Error in Hidden Module: Lookup”
    for every module used in the spread sheet.
    Once the spreadsheet is opened none of the RealStats functions are returning a value. (only VALUE!)
    When I try applying a RealStats function to any data, once selecting the data an error message is shown ” Compile Error in Hidden Module: …..”

    Solver is activated.

    Do you have any suggestions?

    Reply

    • Hi Jon,
      When you select Add-Ins from the Tools menu, do you see RealStats-Mac-2011 and Solver on the list of addins with a check mark next to each of them?
      You don’t need a password, but should not use a blank password.
      Do you get any value when you enter the formula =VER() in any cell?
      Charles

      Reply

        • You don’t need a password. Please answer the following questions:
          1. When you select Add-Ins from the Tools menu, do you see RealStats-Mac-2011 and Solver on the list of addins with a check mark next to each of them?
          2. What do you see when you enter the formula =VER() in any cell?
          3. What do you see when you press Ctrl-m keys?
          Charles

          Reply

          • Hello Charles!
            When I try to analyze by using the Real Statistic. This appeared the same result with other comments above.
            And in Add-in window, I didn’t lick on Solver.
            Lastly, when I try to enter the formula =VER(), the result is exactly “6.0.4 Excel 2010/2013/2016/2019/365 Windows”.

            Do you have any suggestions?
            Many thanks for your support.

  12. Hi Charles,

    I use the 365 Excel version on MacOS High Sierra. I downloaded Real Statistics Resource Pack for Mac 2016. =ver() is 5.7 excel mac 2016. I checked mark RealStat and Solver on the list of addins from the Tools menu. But I can’t see a menu item which seems to be added to Excel’s Add-Ins ribbon. 365 Excel for Mac is not supported by Real Statistics Resource Pack? Could you please help me on this.

    Reply

  13. I just created a bar chart from a raw data for gender for 200 subjects. The labels for the categories however are 1 and 2. I would like the labels to be Males and Females. Is there a way to do this?

    Reply

  14. Dear Charles,
    I just successfully downloaded the 5.5 Resource Pack according to the instructions. I never touched the downloaded file except to save it in the preferred location. When I shut down excel in preparation for downloading the workbooks a password prompt popped up in its place. I was only able to remove the password prompt by rebooting the laptop. I just opened and closed excel again and there is no password prompt so maybe the reboot fixed it. So far I don’t need help. I’m just letting you know what happened.
    Scott Jennings

    Reply

  15. Hey Charles,

    I recently installed your package on 2016 Excel, Version 16.11.
    Whenever I try to designate a cell range, Microsoft Excel just crashes.
    I try to use the Add-Ins tab, but all i see is white blank ribbon
    Its the latest download on your webpage, and I’m not sure whats happening.
    Any help will be appreciated
    Thanks!

    Reply

    • Vanessa,
      When you press Alt-TI do you see RealStats and Solver in the list of addins with check marks next to them?
      What do you see when you enter the =VER() formula?
      Charles

      Reply

  16. I’m also getting the password prompt. I have a 2008 macbook, but up to date software, and Microsoft 2016. all of the links you are posting allow me to open, but possibly not “successfully download”
    Your instructions are not Mac compatible.
    I’m getting the password prompt just after I browse for the download and check the box and click ok.

    I’ve tried electing the blue button where you say “free download” and the version for Mac Microsoft 2016. I get the same result.

    Reply

  18. Hi,

    I am trying to load real stats and it gives me a message –
    Microsoft Visual Basic for Applications prompt

    Cant find project or library

    and when I click ok it takes me to Real Stats Password prompt.

    Also I tried to set this location in Appdata as trusted location

    Please help

    Reply

      • Charles,
        Thank you so much for providing the software and help.

        I had the exact same problem while installing it. Alt-TI doesn’t prompt any window for me, but I can see the Add-ins in Tool tab, and both RealStats and Solver were there and checked. I also tried =VER(), it returned 5.0 Excel Mac. I was able to run KAPPA(E2:F18,2), but when I tried KAPPA(E2:F18,,TRUE), the return is the word “kappa”, instead the chart with kappa, p value etc. And when I tried to run the “reliability” through the “correlation” tab, “compile error in hidden module” message came up.

        Please help! Thank you sooooo much!

        Reply

        • Susan,
          1. The reason why KAPPA(E2:F18,,TRUE) returns only the word “kappa” and not the rest of the information is that KAPPA is an array function and so you can’t simply press Enter to get the results. See the following webpage for information on how to see all the results from KAPPA:
          Array Formulas and Functions
          2. If I understand correctly, you are using Excel 2011 for the Mac. There are two versions of Real Statistics for this version of the Mac. The older version has been tested, but the newer version has not been tested and I can’t guarantee that it works properly. If you have Excel 2016 for the Mac, that version of Real Statistics has been tested and you should use it.
          Charles

          Reply

  19. Hi Charles, Thanks for the great Job. I received this error message will trying to run an ANOVA analysis ”Compile error in hidden module: ANOVA Analysis”. Any suggestions on the way forward?

    Reply

    • Sola,
      Here are some possible issues:
      1. Try using one of the Real Statistics functions. In particular, enter the formula =VER() and see whether you get an error, in which case, the software has not been installed correctly
      2. Solver has not been installed. When you choose the Add-Ins option (after pressing Alt-TI), do you see RealStats and Solver in the list of addins with a check mark next to them?
      3. See Hint 2 at https://real-statistics.com/appendix/faqs/disappearing-addin
      4. The problem might be with the Trust Center settings. Click on Options from the File ribbon and then choose the Trust Center option on the left side. Next click on Trust Center Settings …. Next click on the Macro Settings option on the left side and make sure that it is Disable all Macros with Notification. Also click on the Trusted Locations option on the left side and click on the Add New Location… button to add the folder that contains RealStats folder as a trusted location.
      Charles

      Reply

      • HI
        I installed perfectly and did all the four you suggested
        no in error after typing formula, addins are marked and location modified.
        But it still showing a dailouge box that “compile error in hidden module-ANALYSIS”
        can u please suggest what to do next.

        /vinitha

        Reply

        • Vinitha,
          If you send me an Excel file with your data and tell me which test you were trying to perform, I will try to figure out what the problem is. Also what do you see when you enter the formula =VER() in any cell in an Excel worksheet.
          Charles

          Reply

  20. Excellent package. I came here after looking up Logistic Regression on Google that led me straight here. A good You Tube tutorial made using your package a breeze.

    Reply

  21. I clicked on the “free download” icon for Excel 2016 but an installation box/prompt never appeared. I see add ins but it does ask for a password when I try to use MANOVA. Any suggestions? Thanks

    Reply

    • Brenda,
      Depending on the browser you are using, when you click on the “free download” icon, the file being downloaded (in this case, the RealStats file) will be sent to a specific folder on you computer, usually automatically without any prompts or dialog boxes appearing. This is a function of your browser, not Real Statistics. Once the file have downloaded to your computer, you need to follow the Real Statistics installation instructions as described on the referenced webpage before you can use the Real Statistics data analysis tools (such as MANOVA). Once you understand the instructions, it should only take a minute or two to complete the installation.
      Charles

      Reply

Leave a Comment