Just in case, rename the Real Statistics software. 7. Open Excel and make sure that Solver is checked under Add-Ins 8.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.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 click on the Macro Settings option on the left side and make sure that it is Disable all Macros with Notification. 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. But Im getting this message when i check the real stats after pressing Alt TI Cant find project or library from Microsoft Visual Basic for application. This error commonly occurs when code is incompatible with the version, platform, or architecture of this application. Id 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. 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. You can call Real Statistics functions from within a VBA program. Excel 2016 High Sierra Crashes Everytime I Try To Sort Windows 10 On AEnvironment I have installed RealStats in C:UsersXXXAppDataRoamingMicrosoftAddIns 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. 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 uncheck RealStats, I get the message Cant 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. However, If I save the file, and exit, then the whole problem starts all over again on re-starting Excel. I have also uninstalled and re-installed several times and also read comments from other readers. If I enter VER() in any cell I get 5.11 Excel Mac 2011 Solver is checked under Add-Ins. I have seen similar problems when someone double-clicked on the Real Statistics file (instead of following the installation instructions), resulting in Excel getting confused. Remove all versions of the Real Statistics software (or rename them). Remove all links of Excel to Real Statistics 3. If not step 2 is not complete. Excel 2016 High Sierra Crashes Everytime I Try To Sort Download The RealDownload the Real Statistics for Excel 2011 software from the website 6. Just in case, rename the Real Statistics software. Open Excel and make sure that Solver is checked under Add-Ins 8.
0 Comments
Leave a Reply. |