Data analysis function not working

New Contributor

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?

4 Replies
This is more a VBA type question.

Hi Kate,

 

Do you see these add-ins as active one?

Active.JPG

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.

 

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!

@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