Forum Discussion

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
Sep 06, 2018
Thanks Smitty!

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

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
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
- MarlonD
  Copper Contributor
  Jul 01, 2019
  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.
  - Smitty Smith
    Former Employee
    Jul 01, 2019
    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.