I need to make it clear, in my case, the Data Analysis Toolpak is visible under Data Tab, along with the Solver Add-in.Īlso, Excel Toolpak and Excel VBA Toolpak are available on the list of Active Add-ins in Options-> Add-ins.Īnd, solver add-in is loading normally but not the excel toolpak add-in, once I click it.Īlso, I even tried to deselect the Excel Toolpak from the list of active add-ins and again reactivated it later.Īnd finally, what I noticed is that the above issue happens when I open excel by typing excel in the Start-> Run window.īut, if I click the desktop icon of Excel 2013, then, the Analysis Toolpak and Solver loads normally, if I click on them. Click on the File tab, then Options, and click on the Add-ins tab on the left side of the Excel Options dialog. Youll be prompted to choose from available add. Recently, I noticed that if I click on the Data Analysis Toolpak in Excel 2013, it doesn't LOAD the dialog box with the list of standard statistical operations, such as ANOVA, Regression, etc. Let me show you how to add Data Analysis Toolpak. How to Add Analysis ToolPak in Excel 2016 for Mac Goto tools or Insert menu.

I use Microsoft Office Professional Plus 2013 in windows 8.1.

Data analysis excel toolpak