Forum Discussion

Kate Lufkin's avatar
Kate Lufkin
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..the box with the options of which test to run does not pop up anywhere (and I've looked to see if it's hidden behind another pane, etc.). I've tried un-installing the add on and re-installing it, Restarting my computer, etc...nothing has worked thus far. Any other suggestions?

9 Replies

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor

    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.

     

      • SergeiBaklan's avatar
        SergeiBaklan
        Diamond Contributor

        benmicrosoft5 

        Not sure what do you mean exactly. SIN() is taken radians. To get SIN from degree

        =SIN(RADIANS(30))
    • Kate Lufkin's avatar
      Kate Lufkin
      Copper Contributor

      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's avatar
        AVGElectricalEngineer
        Copper Contributor

        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

Resources