SOLVED
Home

Analysis Toolpak add-in

%3CLINGO-SUB%20id%3D%22lingo-sub-129332%22%20slang%3D%22en-US%22%3EAnalysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-129332%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20tried%20following%20the%20steps%20below%20to%20install%20the%20Analysis%20ToolPak%20onto%20my%20Excel.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3COL%3E%3CLI%3E%3CP%20class%3D%22%22%3EClick%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EFile%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Etab%2C%20click%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EOptions%3C%2FSTRONG%3E%2C%20and%20then%20click%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EAdd-Ins%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ecategory.%3C%2FP%3E%3CP%3EIf%20you're%20using%20Excel%202007%2C%20click%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EMicrosoft%20Office%20Button%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CIMG%20src%3D%22https%3A%2F%2Fsupport.content.office.net%2Fen-us%2Fmedia%2Ff22ae713-addb-400d-bc0f-b7a62f2d61af.gif%22%20border%3D%220%22%20alt%3D%22Office%20button%20image%22%20title%3D%22Office%20button%20image%22%20%2F%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%2C%20and%20then%20click%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EExcel%20Options%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EIn%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EManage%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ebox%2C%20select%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EExcel%20Add-ins%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eand%20then%20click%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EGo%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3EIf%20you're%20using%20Excel%20for%20Mac%2C%20in%20the%20file%20menu%20go%20to%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3ETools%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%26gt%3B%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EExcel%20Add-ins.%3C%2FSTRONG%3E%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EIn%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EAdd-Ins%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ebox%2C%20check%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EAnalysis%20ToolPak%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Echeck%20box%2C%20and%20then%20click%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EOK%3C%2FSTRONG%3E.%3C%2FP%3E%3CUL%3E%3CLI%3E%3CP%3EIf%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EAnalysis%20ToolPak%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eis%20not%20listed%20in%20the%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EAdd-Ins%20available%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Ebox%2C%20click%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EBrowse%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eto%20locate%20it.%3C%2FP%3E%3C%2FLI%3E%3CLI%3E%3CP%3EIf%20you%20are%20prompted%20that%20the%20Analysis%20ToolPak%20is%20not%20currently%20installed%20on%20your%20computer%2C%20click%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3CSTRONG%3EYes%3C%2FSTRONG%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3Eto%20install%20it.%3C%2FP%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FLI%3E%3C%2FOL%3E%3CP%3EHowever%2C%20when%20I%20reach%20the%20stage%20where%20I%20am%20prompted%20to%20install%20the%20Analysis%20ToolPak%20onto%20my%20computer%2C%20I%20click%20Yes%20and%20receive%20the%20following%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EError%201706%3A%20Setpud%20cannot%20find%20the%20required%20files.%20Check%20your%20connection%20to%20the%20network%2C%20or%20CD-ROM%20drive.%3C%2FSTRONG%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20a%20solution%20urgently%20as%20I%20have%20a%20deadline%20on%20the%20work%20I'm%20trying%20to%20complete.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%2C%3C%2FP%3E%3CP%3EAleks%20Duvnjak%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-129332%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-242470%22%20slang%3D%22en-US%22%3ERe%3A%20Analysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-242470%22%20slang%3D%22en-US%22%3EThanks%20Smitty!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-242465%22%20slang%3D%22en-US%22%3ERe%3A%20Analysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-242465%22%20slang%3D%22en-US%22%3E%3CP%3ETry%20the%20Excel%20Add-ins%20option%20instead.%20You%20should%20see%20it%20listed%20in%20that%20dialog%2C%20so%20just%20check%20the%20box%20next%20to%20it.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20559px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F44893i2C866A3D68F37C15%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22Add-in%20dialog.png%22%20title%3D%22Add-in%20dialog.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-242453%22%20slang%3D%22en-US%22%3ERe%3A%20Analysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-242453%22%20slang%3D%22en-US%22%3E%3CP%3EI%20found%20this%20addin%20file%20in%20the%20below%20location%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EC%3A%5CProgram%20Files%20(x86)%5CMicrosoft%20Office%5COffice16%5CLibrary%5CAnalysis%5CANALYS32.XLL%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHowever%20when%20I%20tried%20to%20add%20it%20into%20the%20Excel%20COM%20Addin%20dialog%20box%2C%20I%20got%20an%20error%20message%20indicating%20that%20its%20not%20a%20valid%20addin!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-131347%22%20slang%3D%22en-US%22%3ERe%3A%20Analysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-131347%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Aleks%2C%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20Analysis%20Toolpak%20ships%20as%20a%20part%20of%20Office%2C%20so%20there's%20no%20download%20for%20it.%26nbsp%3BDo%20a%20search%20in%20your%20OS%2FOffice%20drive%20for%26nbsp%3B%3CSTRONG%3EAnalys32.xll%3C%2FSTRONG%3E.%20Once%20you%20find%20it%2C%20you%20should%20be%20able%20to%20use%20that%20in%20the%20add-in%20browse%20location%20dialog.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20me%2C%20it's%20here%3A%26nbsp%3BC%3A%5CProgram%20Files%5CMicrosoft%20Office%5Croot%5COffice16%5CLibrary%5CAnalysis%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHTH%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-523177%22%20slang%3D%22en-US%22%3ERe%3A%20Analysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-523177%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3E%20%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20some%20trouble%20as%20well%20-%20I%20follow%20the%20instructions%20%26amp%3B%20tick%20the%20Analysis%20ToolPak%20add-in%20but%20when%20I%20click%20okay%20it%20doesn't%20do%20anything.%20Help%20-%20also%20on%20a%20deadline!%20I%20need%20boxplots%20that's%20why%20I'm%20trying%20to%20add%20this.%20Any%20ideas%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-525883%22%20slang%3D%22en-US%22%3ERe%3A%20Analysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-525883%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332644%22%20target%3D%22_blank%22%3E%40tamra261%3C%2FA%3E%26nbsp%3B-%20It%20doesn't%20really%20do%20anything%20from%20that%20dialog%20other%20than%20activate%20it.%20Once%20you%20activate%20it%20through%20the%20add-ins%20menu%2C%20go%20to%20the%20Data%20tab%2C%20and%20look%20for%20the%20Analysis%20group.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-732867%22%20slang%3D%22en-US%22%3ERe%3A%20Analysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732867%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F332644%22%20target%3D%22_blank%22%3E%40tamra261%3C%2FA%3EHello%2C%20have%20you%20gotten%20this%20fixed%3F%26nbsp%3B%20I%20am%20having%20the%20same%20problem%20and%20cannot%20seem%20to%20move%20on.%26nbsp%3B%20I%20have%20followed%20all%20of%20the%20steps%20outlined%20but%20the%20toolpak%20still%20doens't%20show%20up%20in%20the%20ribbon.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-732871%22%20slang%3D%22en-US%22%3ERe%3A%20Analysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732871%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F369530%22%20target%3D%22_blank%22%3E%40MarlonD%3C%2FA%3E%26nbsp%3BAre%20you%20looking%20at%20the%20Data%20tab%20after%20you%20activate%20the%20Analysis%20Toolpak%3F%20Here's%20what%20it%20looks%20like%20in%20my%20Excel%20for%20O365.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F121808iF597859005013C3D%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22AnalysisToolpak.jpg%22%20title%3D%22AnalysisToolpak.jpg%22%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-caption%22%20onclick%3D%22event.preventDefault()%3B%22%3EAnalysis%20Toolpak%20on%20the%20Data%20tab%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-732940%22%20slang%3D%22en-US%22%3ERe%3A%20Analysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732940%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3Ethanks%20for%20the%20quick%20response.%26nbsp%3B%20I%20am%20seeing%20that%20but%20i%20am%20expecting%20to%20see%20the%20Analysis%20option%20under%20the%20Add-in%20tab%2C%20which%20I%20am%20not%20seeing.%26nbsp%3B%20Actually%2C%20I%20am%20trying%20to%20conduct%20a%20test%20of%20multicollinearity%20on%20some%20data.%26nbsp%3B%20The%20Add-in%20tab%20keeps%20appearing%20and%20disappearing.%26nbsp%3B%20When%20it%20appears%20though%2C%20only%20the%20%22Tanagra%22%20add-in%20(%3CEM%3Ea%20data%20mining%20software%20I%20sometimes%20use%3C%2FEM%3E)%20is%20there%2C%20nothing%20else.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-732953%22%20slang%3D%22en-US%22%3ERe%3A%20Analysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-732953%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F369530%22%20target%3D%22_blank%22%3E%40MarlonD%3C%2FA%3E%26nbsp%3BThat's%20because%20the%20Analysis%20Toolpak%20is%20only%20loaded%20on%20the%20Data%20tab.%20The%20add-ins%20tab%20appearing%2Fdisappearing%20sounds%20like%20something%20dynamically%20loading%2Funloading%20your%20Tanagra%20add-in.%20That's%20not%20the%20Analysis%20Toolpak%20doing%20anything.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-733032%22%20slang%3D%22en-US%22%3ERe%3A%20Analysis%20Toolpak%20add-in%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733032%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F10827%22%20target%3D%22_blank%22%3E%40Smitty%20Smith%3C%2FA%3EThanks%20much.%26nbsp%3B%20I%20see%20your%20point!%26nbsp%3B%20I%20was%20still%20expecting%20to%20see%20Multicollinearity%20test%20as%20an%20option%20but%20I'll%20try%20to%20figure%20it%20out.%26nbsp%3B%20Will%20let%20you%20know%20if%20I%20am%20successful.%20%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
aleks duvnjak
Occasional Visitor

I have tried following the steps below to install the Analysis ToolPak onto my Excel. 

 

  1. Click the File tab, click Options, and then click the Add-Ins category.

    If you're using Excel 2007, click the Microsoft Office Button Office button image , and then click Excel Options

  2. 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.

  3. 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.

 

Thanks,

Aleks Duvnjak

11 Replies

Hi Aleks,

 

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

 

HTH

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!

Try the Excel Add-ins option instead. You should see it listed in that dialog, so just check the box next to it.

 

Add-in dialog.png

Solution
Thanks Smitty!

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?

 

Thanks

@tamra261 - It doesn't really do anything from that dialog other than activate it. Once you activate it through the add-ins menu, go to the Data tab, and look for the Analysis group. 

@tamra261Hello, have you gotten this fixed?  I am having the same problem and cannot seem to move on.  I have followed all of the steps outlined but the toolpak still doens't show up in the ribbon.  

@MarlonD Are you looking at the Data tab after you activate the Analysis Toolpak? Here's what it looks like in my Excel for O365.

 

AnalysisToolpak.jpgAnalysis Toolpak on the Data tab

@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. 

@MarlonD That's because the Analysis Toolpak is only loaded on the Data tab. The add-ins tab appearing/disappearing sounds like something dynamically loading/unloading your Tanagra add-in. That's not the Analysis Toolpak doing anything.

@Smitty SmithThanks much.  I see your point!  I was still expecting to see Multicollinearity test as an option but I'll try to figure it out.  Will let you know if I am successful.