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.....
BI & Data Analytics
Need Help
Kate Lufkin's avatar
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's avatar
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's avatar
    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's avatar
      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

      • DWG_117's avatar
        DWG_117
        Copper Contributor
        Jul 13, 2023

        Ricardo_Monteiro 

         

        This links to insights.microsoft.com - make sure that's not being filtered or blocked by Firewall (Had issues with this using Zscaler)

Resources