Forum Discussion

aleks duvnjak's avatar
aleks duvnjak
Copper Contributor
Nov 18, 2017
Solved

Analysis Toolpak add-in

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

BI & Data Analysis
excel

18 Replies

Sort By
  • student5687's avatar
    student5687
    Copper Contributor
    Jun 17, 2020

    i'm trying to find the add-ins option. but following the instructions given " go to file>> options>> add-ins"  when i open file there is no "options" only settings

  • Smitty Smith's avatar
    Smitty Smith
    Former Employee
    Nov 26, 2017

    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

    • Piero85's avatar
      Piero85
      Copper Contributor
      Jun 02, 2020

      Smitty Smith 

      i ave activated the Analysis Toolpak add-in for my Excel 2016 and when I look under data tab there is no analysis sub tab showing. i ve checked my trust center to see if there was any block for .XLL files but there is no block. What could be preventing the add ins to show on my bar? is there another way to have the analysis toolpak run?

      • Student610's avatar
        Student610
        Copper Contributor
        Jun 02, 2020

        Piero85 I am having the same issue. everything is installed an well but it doesn't show the analysis toolpak in my bar.

    • tamra261's avatar
      tamra261
      Copper Contributor
      May 03, 2019

      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

      • MarlonD's avatar
        MarlonD
        Copper Contributor
        Jul 01, 2019

        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.  

    • Bharat Anand's avatar
      Bharat Anand
      Copper Contributor
      Sep 06, 2018

      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!

      • Smitty Smith's avatar
        Smitty Smith
        Former Employee
        Sep 06, 2018

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

         

Resources