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.

benmicrosoft5
Copper Contributor
Jan 17, 2023
I need the steps to find the sin of 30 degree
- SergeiBaklan
  Diamond Contributor
  Jan 21, 2023
  benmicrosoft5
  
  Not sure what do you mean exactly. SIN() is taken radians. To get SIN from degree
  
  =SIN(RADIANS(30))
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