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.    Click the File tab, click Options, and then click the Add-Ins category. If you're using Excel 2007, click...
BI & Data Analysis
excel
  • Bharat Anand's avatar
    Bharat Anand
    Sep 06, 2018
    Thanks Smitty!
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.  

      • Smitty Smith's avatar
        Smitty Smith
        Former Employee
        Jul 01, 2019

        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.

         

        Analysis Toolpak on the Data tab

    • Smitty Smith's avatar
      Smitty Smith
      Former Employee
      May 03, 2019

      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. 

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

       

      • SamVT's avatar
        SamVT
        Copper Contributor
        Aug 26, 2019

        I am trying to download the Analysis ToolPak. I got to word/file/add-ins but the option to choose Analysis ToolPak is not an option. I read to choose browser and search for it but there is alsono browser on link. Not sure what to do and my assignment is due today. Your help would be greatly appreciated Smitty Smith 

Resources