Forum Discussion

Copper Contributor

Aug 28, 2017

Data analysis function not working

Good afternoon, I am using Excel 2013. I have added in the Data Analysis add-on (and the VBA one). The data analysis button shows up on the right of my toolbar, but when I click it nothing happens.....

BI & Data Analytics

Need Help

SergeiBaklan

Diamond Contributor

Sep 28, 2017

Hi Kate,

Do you see these add-ins as active one?

to be sure they are installed. Try uncheck and check back in Manage add-ins at the bottom of optons, restrting the Excel after each.

Kate Lufkin

Copper Contributor

Sep 28, 2017

Yes, they were added in. Thank you! My work fixed the problem. Not sure what it was, but it was something on the IT end at my job, it has been fixed. Thanks, everyone!

AVGElectricalEngineer
Copper Contributor
Jun 30, 2021
Kate Lufkin
I know it has been some time but do you know what your IT did to get this working for you?
I am currently having the same problem

Thanks
- ManusIGFS
  Copper Contributor
  Sep 10, 2021
  AVGElectricalEngineer
  Hope you got it sorted but if not.
  As suggested above.
  Options-> Add-ins-> Manage-> Un-tick the Analysis Tool{ak add-in, close Excel.
  Restart Excell and add it back in.
  Just worked for me.
  Good luck
  - Ricardo_Monteiro
    Copper Contributor
    Jan 12, 2023
    ManusIGFS
    
    I know is a long time but I did that but my button appears but when I click it only the side panel appears with nothing in it