11-18-2017 08:24 AM
11-18-2017 08:24 AM
I have tried following the steps below to install the Analysis ToolPak onto my Excel.
Click the File tab, click Options, and then click the Add-Ins category.
If you're using Excel 2007, click the Microsoft Office Button , and then click Excel Options
In the Manage box, select Excel Add-ins and then click Go.
If you're using Excel for Mac, in the file menu go to Tools > Excel Add-ins.
In the Add-Ins box, check the Analysis ToolPak check box, and then click OK.
If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.
If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
However, when I reach the stage where I am prompted to install the Analysis ToolPak onto my computer, I click Yes and receive the following:
Error 1706: Setpud cannot find the required files. Check your connection to the network, or CD-ROM drive.
I need a solution urgently as I have a deadline on the work I'm trying to complete.
11-26-2017 02:10 PM - edited 11-26-2017 02:11 PM
The Analysis Toolpak ships as a part of Office, so there's no download for it. Do a search in your OS/Office drive for Analys32.xll. Once you find it, you should be able to use that in the add-in browse location dialog.
For me, it's here: C:\Program Files\Microsoft Office\root\Office16\Library\Analysis
09-05-2018 05:45 PM
I found this addin file in the below location:
C:\Program Files (x86)\Microsoft Office\Office16\Library\Analysis\ANALYS32.XLL
However when I tried to add it into the Excel COM Addin dialog box, I got an error message indicating that its not a valid addin!
05-02-2019 10:28 PM
Hi @Smitty Smith ,
I am having some trouble as well - I follow the instructions & tick the Analysis ToolPak add-in but when I click okay it doesn't do anything. Help - also on a deadline! I need boxplots that's why I'm trying to add this. Any ideas?
07-01-2019 01:34 PM
@Smitty Smiththanks for the quick response. I am seeing that but i am expecting to see the Analysis option under the Add-in tab, which I am not seeing. Actually, I am trying to conduct a test of multicollinearity on some data. The Add-in tab keeps appearing and disappearing. When it appears though, only the "Tanagra" add-in (a data mining software I sometimes use) is there, nothing else.