The Add-Ins tab in Excel 2013 is not showing up even when the add-in is loaded. I perform the following steps:. Open Excel. Enable the add-in via Excel File Options Add-Ins Excel Add-ins Check the box next to my add-in The Add-Ins tab is displayed and I can use the add-in's custom functions in my workbook.
However, when I close Excel 2013 and re-open my workbook the Add-Ins tab does not show up but the add-in is loaded just fine. My custom functions still work and I can copy/paste them to create new ones. The add-in is working, but the ribbon tab is not there. I have searched the internet and found some information regarding an issue with the Analysis Toolpak add-in and how this one must be loaded last for some reason, but this does not apply to me because I have no other add-ins enabled at all. I have also tried to run Excel as an administrator to enable the add-in and re-open Excel as an administrator but the Add-Ins tab is still missing. I have looked through all the options and the Trust Center but do not see anything that should be causing this issue (all the disable options for add-ins in the Trust Center are unchecked) but the problem persists! I do not receive any errors and this behavior with this same add-in does not happen in Excel 2007 (I have not checked Excel 2010 because I really don't want to install yet another version of Excel to test this!).
Does anyone have any tips for me? It is very frustrating for me and my users to have to open Excel, uncheck the add-in, close Excel, open Excel, re-check the add-in just to get the Add-Ins tab to show up! So, why is my custom ribbon/menu not being persisted in Excel 2013 while it is persisted in Excel 2007 and 2003 using the same add-in? - because starting with Excel 2010, Excel is now a Mutiple Document Interface (MDI), previous versions were Single Document Interface. I think you ll find an answer to your question with the following post ( see the'Solutions for SDI Issues'; Third paragraph - 'Toolbars added.' In short you need to use Application.Windows instead of workbooks to add the ribbon control.
I have re-created my issue with the smallest amount of code possible. In Excel 2013, I create an Excel 97-2003 Add-in file named AddCustomMenu.xla. Thanks for the reply! Yes, I see that this will make the Add-Ins tab visible in Excel 2013. However, we should really only need to add this custom menu one time: when the addin is installed. It only needs to be removed one time: when the addin is uninstalled. I have users running Excel 2007 and even Excel 2003 and this.xla works as expected in these versions (the Add-Ins tab and custom menu is visible in every instance of Excel after they have enabled the add-in with the code to add the custom item in WorkbookAddinInstall).
![Megastat Megastat](/uploads/1/2/5/4/125424083/833729162.jpg)
I have not tested Excel 2010, so I do not know the behavior there. My company never upgraded to that version so none of my users have it.
An installation guide for 2007, it is assumed that you have MegaStat, the program will not be made available. When he closes the workbook by clicking the close button at the upper-right of the program window, the workbook closes but Excel remains open. I avoid this now by opening a blank workbook when Excel is started for the first time, but it isn't a very elegant solution to a problem I didn't have until.
So, why is my custom ribbon/menu not being persisted in Excel 2013 while it is persisted in Excel 2007 and 2003 using the same add-in? Is this a functionality change in Excel 2013 on purpose? Is it a bug in Excel 2013?
Is there a different way to customize the ribbon in a persistent way using an Excel (not COM) Add-in in Excel 2013? So, why is my custom ribbon/menu not being persisted in Excel 2013 while it is persisted in Excel 2007 and 2003 using the same add-in? - because starting with Excel 2010, Excel is now a Mutiple Document Interface (MDI), previous versions were Single Document Interface. I think you ll find an answer to your question with the following post ( see the'Solutions for SDI Issues'; Third paragraph - 'Toolbars added.' In short you need to use Application.Windows instead of workbooks to add the ribbon control.
The Real Statistics Resource Pack contains a variety of supplemental functions and data analysis tools not provided by Excel. These complement the standard Excel capabilities and make it easier for you to perform the statistical analyses described in the rest of this website.
We now explain how to download and install the Real Statistics Resource Pack for use with Excel 2010, 2013, 2016 (Windows) or 2019 (Windows). If you are using Excel 2007.
If you are using Excel 2003 or a prior version of Excel. If you are using Excel for the Macintosh. Keep in mind that there are also two versions of Excel, at least for Excel 2010, 2013, 2016 and 2019, the 32 bit version and the 64 bit version.
Most people use the 32 bit version. The Real Statistics Resource Pack works in both versions of Excel. Download Real Statistics Resource Pack for Excel 2013, 2016 or 2019 If you accept the, click here on to download the latest Excel 2013/2016/2019 version of the resource pack that accompanies this website (Release 5.9). This software is compatible with Excel 2013 and 2016 and is named RealStats.xlam. After downloading the software make sure that you install the software as described below. Downloading this resource pack means that you accept the.
If you accept the, click here on to download the latest Excel 2010 version of the resource pack that accompanies this website (Release 5.9). This software is compatible with Excel 2010 and is named RealStats-2010.xlam. After downloading the software make sure that you install the software as described below.
Downloading this resource pack means that you accept the. Real Statistics Resource Pack for Excel 2002, 2003 or 2007 If you are using Excel 2007, for instructions on how to download and install the Real Statistics Resource Pack. If you are using Excel 2003 or a prior version of Excel, for instructions on how to download and install the Real Statistics Resource Pack. Real Statistics Resource Pack for Excel 2011 or 2016 for Mac If you are using a Macintosh version of Excel 2011/2016, for instructions on how to download and install the Real Statistics Resource Pack.
Installation Before trying to install the Real Statistics Resource Pack make sure that Excel’s Solver capability is installed on your computer. Check this as follows:.
Open up a blank Excel spreadsheet. Press Alt-TI (i.e. Hold down the Alt key and press the T and I keys). On the dialog box that appears make sure that the Solver addin is checked. If not, check it and click on the OK button. If the Solver addin was not checked you need to close the Excel file before proceeding to the next step.
Once you have downloaded the Resource Pack and made sure that Solver is installed, you need to install the Real Statistics Real Pack using the following steps:. Move the Resource Pack to where you want it located on your computer (see our recommendation below). Caution: once you install the resource pack at a particular location it will be more difficult to move it later. Open Excel, but don’t try to open the realstats.xlam file that you downloaded earlier. Select File Help Options Add-Ins and click on the Go button at the bottom of the window (see Figure 1). Alternatively you can simple press Alt-TI (i.e.
Hold the Alt key down and simultaneously press T followed by I) and the dialog box shown in Figure 2 will appear. Figure 2 – Add-ins dialog box 2 While you can place the Real Statistics Resource Pack anywhere on your computer, we recommend that you put the file in the following folder: C: Users user-name AppData Roaming Microsoft AddIns where user-name is your user name in Microsoft Windows. Since some of these folders are hidden, you may find it convenient to enable showing hidden folders. E.g., in Window 7 you can do this by opening the Control Panel, clicking Appearance and Personalization, and then clicking Folder Options and then clicking the View tab.
Now in the Advanced settings, click Show hidden files, folders, and drives, and then click OK. Installation of Upgrades Once you have installed the Real Statistics Resource Pack as described above, to install a new version of the software you don’t need to repeat these steps. You only need to delete the previous version of the resource pack and put the new version of the software in the same location as the previous version. Troubleshooting If there is a problem during the installation try one or more of the following:.
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.
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.
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. Real Statistics Functions Once you have installed the Real Statistics Resource Pack you can use the Real Statistics functions in the same way as you use the built-in worksheet functions supplied with Excel. These functions are described throughout the rest of this website. A complete list of these functions can be found in. Real Statistics Data Analysis Tools You can access the Real Statistics data analysis tools in one of the following ways, as described in:. By pressing Ctrl-m or. By clicking on an icon on the Add-Ins ribbon or.
By clicking on an icon on the Quick Access Toolbar or. Via the Macro dialog box A dialog box will now appear which lists all the available Real Statistics data analysis tools. You need to choose one of the data analysis tools from this list. A dialog box will then appear as described in which enables you to specify your input data and choose from available options.
You can also access Help to get more information about the selected data analysis tool. A complete list of Real Statistics data analysis tools can be found in.
Uninstalling the Real Statistics Resource Pack. Open Excel. Press Alt-TI. Uncheck the Realstats option on the dialog box that appears and click the OK button. Close Excel and delete the file that contains the Real Statistics Resource Pack.
Charles, Please, to your installation instructions for Excel 2016, add this step. FileOptionsTrust CenterTrust Center SettingsTrusted LocationsAdd new locationBrowse C: Users username AppData Roaming Microsoft AddIns ok. In fact Excel 2016 refuses to even start-up if you don’t perform the above-mentioned step.
I have been a big fan of your work since many years, and have introduced real-statistics add-in to my students. However, I was surprised that you don’t write many research articles, which should be really easy for someone like you who understands data analysis so well. I am curious to know what you are doing these days. And by the way congrats on publication of your book on Excel. An admirer from Pakistan!
Hi Charles, I’m really interested by your plugin which seems to be exactly what I’ve been looking for since I started using Excel a long time ago. I’ve just installed the 2010 version onto my computer and the installation seemed to go fine. I restarted Excel and tried it out, but not of the functions (eg. =DPTEST(C6:C16)) are working I just keep getting Excel asking if I typed a name. Could it because I’m using French Excel and the names of the functions are often different (eg. =STDEV is =ECARTYPE)? I hope I can get this working it would be a great aid to me Andrew.
Hi Andrew, The software should work no matter which language for Excel you use, including French. I use the Italian and English versions myself. If when you enter the formula =VER you get and error, then the software was not installed or was not installed properly. When you press Alt-TI you should see RealStats-2010 and Solver on the list of addins with a check mark next to them. If not the software was not installed. See the webpage where you downloaded the software for the installation instruction.
This only takes a couple of minutes, but it does need to be done. Hi Charles, Thanks for your reply. That’s great news that RealStats works on non-english installations of office. I tried =VER and Excel is asking if I typed a name, so it looks like a bad installation. However, I did follow the instructions to the letter. Alt-TI doesn’t work on my French installation and I’m not sure what the equivalent is, but when I go to file/options/addins/go (or the french equivalent) I get the window and Solver and RealStats2010 are both ticked. This might be the same problem others were having with 2010 64-bit Excel.
I’ll try reinstalling and installing on another computer. So I just installed RealStats on another PC. Both are running Windows 7 and Excel 2010 but the one I just installed on is 32-bit Windows. I did exactly the same as the first install and it works. I also tried copying the newly downloaded (and working) RealStats-2010.xlam file to replace the one that isn’t working. That didn’t help either so it may be a 64-bit issue. I also tried this just in case but no joy: “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 RealStats folder as a trusted location.”. I finally figured out the 64-bit install issue! It appears to be a trust issue with the XLAM file itself.
Looks like a new Windows “feature” introduced recently Try this (either before or after installing): 1. Go to where the RealStats.xlam file is located (see above). Right click on the file, select Properties and look at the bottom for the following: “Security: This file came from another computer and might be blocked to help protect this computer”. There is an Unblock check-box next to this warning. Check the Unblock check-box, close Properties, and the security message disappears. After doing the above, and opening Excel in the normal way, =ver and Ctrl-m work as expected. Hi Charles, I wanted to let you know that the real-stats tool is very helpful in my everyday work.
While working recently on “Time series” calculations for a set of 20 data points, I observed that whether I check “Simple moving average” or “Weighted moving average”, the tool derives only a simple moving average and the header for the forecast table also reads “Simple moving average” though other parameters like weights that I assigned have been included in the calculation/visible in the output. The MAE/MSE values, though are different across the categories (Simple moving and weighted moving averages).
With my limited knowledge, I think this is a bug in the tool. Thank you for looking into this! Best regards, Natraj.
Dear Charles, Thank you so much for providing this wonderful package! Initially, I had some problems with installation, and perhaps the solution I found may be useful for others. The App Data folder was not visible in my Win10 file explorer. However, by selecting the file in the download folder and then selecting the “Move to ” option, I could navigate to this folder and select the microsoft Addins folder as location. I think you should move the recommendation to right click the file first of all and check “unlock” under properties. Once again, thank you for sharing this resource with everyone!
Mr Charles Thank you for this site and add-in it’s a great help. I want to ask you this: A friend of friend consulted me for her research. She wants to know if there is a significant difference in lead content in water after putting fish scales.
For the first experiment she put 100 grams of fish scale, on the second 110 grams and on the third 120 grams. Per experiment she only have 1 observation.
Initially I said that there is no statistical treatment for it. Am i correct? Or is there a treatment ideal for that? Thanks ahead!
If the resource pack is properly installed, you should get a valid output for the formula =VER and you should be able to press Ctrl-m and use the Descriptive Statistic data analysis tool. I don’t think you will be able to use the 2013/2016 version of Real Statistics with Excel 2010 3. The differences are quite minor. In the 2010 version, the HYPEGEOMINV and NEGBINOMINV functions are not supported. Also all the Real Statistics functions are considered to be user-defined functions in Excel’s function help capability. Javin, Here are three potential reasons for this problem: 1.
Solver has not been installed. When you choose the Add-Ins option from the Tools menu, do you see RealStats and Solver in the list of addins with a check mark next to them? See Hint 2 at 3. 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 RealStats folder as a trusted location. Dear Charles, many thanks for the Real Statistics – it’s the best and most comprehensive add-in for Excel I have ever tried. The only issue I have encountered is related to different user names when working with different computers: I used correlation function on one PC, then copied the file and tried to continue the work on another PC, but I have got #NAME? In many cells, which I solved partly by changing user name in the formula bar manually.
While I was not able to do so with the array formulas. I think it should be a simple solution there as the installation directories principally are the same on both PCs: C: Users user-name AppData Roaming Microsoft AddIns. Thank you very much, Juozas. Hi – I have followed the installation method but I can’t find a way to run the add-in. Ctrl-m doesn’t seem to do anything and there’s nothing on the macros page.
When I go to customize the ribbon, the Add-in tab is ticked but I can’t add/remove anything to it and there’s no realstats symbol / word contained in the exploded list. I have found that if I press AltTI then uncheck and re-check the RealStats add-in, then press ok, the Add-in tab and RealStats symbol appear and work. However, if I save and close, when I re-open excel, the tab has gone again and I have to re-do the above to gain access!
Any help much appreciated! Ctrl-m should work, unless this key combination is being used by some other addin. Regarding RealStats disappearing from the Addins ribbon and related issues, please see the following webpage: 3. If you choose Macros from the View ribbon and then insert InitStats in the dialog box that appears and then click on the Run button, you will be able to run the Real Statistics data analysis tools. This is not the easiest approach, but it should work.
The various Real Statistics functions should be available even if you don’t do any of the above steps. To make sure this capability is working, just enter the formula =VER in any cell and you should get some information about the Real Statistics release. Hi, I had the same problem even though I have followed the instructions in this page.
In my first (and failed) attempt to install the add-in, I have downloaded the RealStats.xlam to the Downloads folder and then made a copy in the suggested folder. Since the add-in is not working as expected, what I did is to delete the copies of RealStats.xlam that I have. Then I downloaded the file directly to the suggested folder ( Users AppData Roaming Microsoft AddIns) and followed the installation procedure.
Now the add-in seems to work. I hope this helps.
Hi Charles, Downloaded the latest 4.13 version. I have not had problems with a download for quite some time. But I had the following occur today.
After removing old version and replacing with new version, and marking the Block indicator on Properties screen, when Excel 2013 starts, an error message arises indicating wrong format of file or corrupt file. The resource package will not load. I do see that the download file is 1.3Mb-ish, and older versions of the resource pack are 2.5Mb-ish. I tried a few download attempts.
I was able to resort to previous version with no problem. If you or others don’t see the same thing happenI guess I will look for some other reason. Regards, Rich. I don’t know why you would need to reinstall the package every time you open Excel. Can you access the Real Statistics software when you press Ctrl-m? Are you saying that Real Statistics disappears from the ribbon or that it doesn’t work at all and you need to press Alt-TI each time you open Excel and put a check mark next to the RealStats add-in in the list of add-ins? Or are you doing something else?
Can you use the POISSONINV function in Excel? If you can do this, but would like to also access it in a VBA program that you are writing, then please look at the following webpage: Charles.
I’m having issues installing this with recently updating to 32 bit Office 2016 Excel. After I install the plugin and exit Excel and reopen, it seems to forget the plugin.
I have to reinstall it every time I want to use it. It still shows up under the plugins list but none of the functions show up when typing question nor ctrl-m works.
Also all my old excel sheets are showing up like this: =’C: RealStats.xlam’!FRIEDMAN(A4:AB16) which is strange because I installed the plugin in the directory suggested above. Any thoughts?