Answered By: Alyssa Mitchell
Last Updated: Jun 29, 2020     Views: 1173282


If the Data Analysis command is not available in your version of Excel, you need to load the Analysis ToolPak add-in program. These instructions apply to Excel 2010, Excel 2013 and Excel 2016.

  1. Click the File tab, click Options, and then click the Add-Ins category.
  2. In the Manage box, select Excel Add-ins and then click Go.
  3. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

Tip: If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

If you are prompted that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

Once the add in has been successfully installed you will see data analysis when you click on the data tab (usually to the far right of the toolbar). Go back to the first screenshot in the instructions to see how it will look. The button will open the Data Analysis dialog, which offers access to a variety of analysis tools.


Quick Analysis is a similar set of tools available in Excel 2013.  See Microsoft documentation for more information. it applies to Excel 2013 and Excel 2016. 

~ Instructions provided courtesy of Excel Help


Comments (68)

  1. You have made some really good points there. I checked on the internet for more additional information about the issue and found most people will go along with your views on this site.
    by gary on May 02, 2016
  2. You can find the instructions here along with the tutorial on how to use it to make a histogram:
    by Hans on Dec 28, 2016
  3. When I open the Options menu the Add-Ins tab is not there. I have excel 2010. I need to be able to use data analysis for a stats class. Any ideas why it's not there?
    by awhitaker on Jan 30, 2017
  4. it was totally a helpful one thanks a lot
    by zikersp on Mar 13, 2017
  5. Thanks.. very insightful
    by usman on May 13, 2017
  6. Thanks a lot for your instruction, was clear and useful.
    by ramadan on Oct 07, 2017
  7. Thanks a lot for your instruction. It's help me to start analysis in xls.
    by Rajeev on Dec 10, 2017
  8. Thank You!
    by Rivera on Jan 15, 2018
  9. this really help me a lot. thanks!
    by cuja on Mar 23, 2018
  10. This was really helpful, so clear and straight to the point. Thank you so much.
    by Mavis on Apr 09, 2018
  11. The Analysis Toolpak is installed. The Data Analysis button is not there. This is Excel 2013. Frustrated!
    by Paul on Apr 19, 2018
  12. I installed the Analysis toolpak, but there is no button for it. What's wrong?
    by Larry Brunner on May 09, 2018
  13. Thank you very much for the easy to follow instruction !
    by Ashutosh on May 11, 2018
  14. @Larry - you might need to close the program and open it again.
    by Katie Hutchison on May 14, 2018
  15. Thank you very much for your help, it does even in my Microsoft Office 2007.
    From Dar es Salaam, Tanzania.
    by Ezekiel on May 16, 2018
  16. i could not find slicer option in excel 2007 . please anybody help me.
    by Bedanta on Jul 04, 2018
  17. @Bedanta - Unfortunately it looks like slicers are not available for any Excel product prior to 2010. That being said, I found this discussion thread that discusses possible alternatives, I hope this helps!
    by Alyssa Mitchell on Jul 05, 2018
  18. fantastic
    thank you very much
    by charles on Jul 07, 2018
  19. THANK YOU!!!
    by anonymous on Aug 10, 2018
  20. Much appreciated!
    by El Ocho on Oct 14, 2018
  21. Thanks really helpful
    by Navi Rathee on Oct 27, 2018
  22. thank you very much
    by sateesh kumar tk on Jan 03, 2019
  23. Thanks!
    by Raiz on Jan 11, 2019
  24. Wow! Saved me hours of looking for something I didn't have. Thank you so Much. Bless your brain.
    by Pebbles on Mar 07, 2019
  25. I have de-selected and re-selected Analysis ToolPak several times but the Analyze group is nowhere on the Data tab ribbon, despite repairing or removing and reinstalling the Office software. The ANALYS32.XLL file is in the folder "C:\Program Files\Microsoft Office\root\Office16\Library\Analysis", tried relocating this file in %APPDATA%\Excel\Library\Analysis , without success.
    by C.G. on May 31, 2019
  26. @C.G. while the technical aspects of this aren't our specialty, I did find an answer to your question.
    by Michael Jundi on May 31, 2019
  27. Thank you very much!
    by SagkaT on Jun 20, 2019
  28. Really a good video....i can easily able to resolve the issue in 10 min
    by DAMODARAN on Dec 06, 2019
  29. In some other versions of Excel, Excel Add-Ins in available under "Tools" menu.
    by Ashara on Feb 04, 2020
  30. thank you
    by efgsegfv on Feb 18, 2020
  31. I have the same problem as C.G. Pls help. I entered =networkdays(a1,a2) in a cell and showed 0, meaning the analysis toolpak was loaded, but not showing the data analysis tab
    by Meeko on Feb 21, 2020
  32. @Meeko - Try looking under the Data tab as sometimes it goes under there instead of as it's own separate tab. If that doesn't work, I suggest reaching out to Microsoft directly as they are better qualified to help answer these questions. For help from Microsoft, start here, I hope this helps! Good luck!
    by Alyssa Mitchell on Feb 22, 2020
  33. thank you so much. saved my friend from failing her labs.
    by jennifer on Mar 05, 2020
  34. Hello, I understand the instructions, but the Data pack add-in is not showing and the Browse button only browsers my own computer, not the web/XL site to enable me to download it. Any advice?
    by debbie on Mar 12, 2020
  35. Where do I find the data analysis tookpak? Is it downloadable from the web? It's not on my PC
    by debbie on Mar 12, 2020
  36. @debbie - What version of Excel are you using and are you on a PC or Mac computer? I can try and help troubleshoot remotely, but if you can come into our library or your local public library that may be best.
    by Alyssa Mitchell on Mar 13, 2020
  37. Thank You.. :)
    by Suvarna on Mar 16, 2020
  38. Thank you very very much! This method really works following your step-by-step instruction :D
    by Leah on May 30, 2020
  39. Thank you so much!!
    by Raf on Jun 30, 2020
  40. Instructions were followed. Got the data analysis on the ribbon under DATA. But then it disappeared. Repeated the procedure but it still does not appear on the ribbon.
    by shz on Sep 07, 2020
  41. @shz - I am sorry that it is not showing up now for you. Without being able to see your screen, I am not sure how to tell what the issue is. I would recommend bringing it into your local public library to see if they can help troubleshoot. I hope they are able to help you!
    by Walsh U Library on Sep 08, 2020
    by urvi on Nov 05, 2020
  43. Thank you ... very helpful
    by Khalid Al-Hagla on Nov 13, 2020
  44. Precise and to the point Thanks very much
    by TT on Nov 14, 2020
  45. Thank you
    by Sandali on Dec 16, 2020
  46. thank you
    by KK on Feb 25, 2021
  47. I have the same problem as @G.C. I have selected the Add-in but it still won't show up in the Data Tab nor in the Home Tab. Can anyone help me with this?
    by Mohammed Shoaeb on Mar 09, 2021
  48. @Mohammed Shoaeb I am sorry you are having the same issue. Unfortunately, I am not sure how to assist you without being able to see your screen. One of the librarians here had responded to @C.G. with a Microsoft help article they had found addressing the topic: I hope this helps!
    by Walsh U Library on Mar 11, 2021
  49. Thank you very much
    by Danté on Apr 10, 2021
  50. Thank you, it's helpful to me a lot.
    by Mohamed Kombora on May 31, 2021
  51. thank you
    by robin on Jun 03, 2021
  52. Thank you so much, this is so helpful
    by Mey on Jun 17, 2021
  53. Thanks for sharing this information
    by Mrinal on Jun 17, 2021
  54. Thank you! This really drive me crazy
    by TOMORROW X TOGETHER on Jun 29, 2021
  55. still doesn't appear, what could be wrong?
    by daniel on Jul 05, 2021
  56. @daniel I am sorry it is not showing up for you. Unfortunately, I am not sure how to assist you without being able to see your screen. One of the librarians here had responded to @C.G. and @Mohammed Shoaeb with a Microsoft help article they had found addressing the topic: I hope this helps!
    by Walsh U Library on Jul 08, 2021
  57. thank u, i followed the instruction. the data analysis button did not appear. i read the comments and @katie suggested to close the program or the excel file and re-open it. it worked. thanks to all of you for sharing your knowledge
    by alma on Aug 06, 2021
  58. Thanks for the tutorial. Unfortunately, I couldn't make it work with my Excel 2019. For those who use Excel 2013, 2016, or 2019, the instructions in this article should helped me turn on the Quick Analysis tool: To save other users some time, here's how you do it: File > General > check the "Show Quick Analysis options on selection" box > OK.
    by Felix on Aug 26, 2021
  59. your video guide is easy to understand. I have installed the data analysis.
    by emmanuel on Sep 04, 2021
  60. Very is working fine in excel 2013...thank you so much
    by Gayatri on Oct 01, 2021
  61. this is very helpful
    by jio on Feb 18, 2022
  62. Thank you so much
    by Tsepi on Mar 22, 2022
  63. thx alot
    by boon on Mar 22, 2022
  64. I have to convey my respect for your kindness for all those that require guidance on this one field. Your special commitment to passing the solution up and down has been incredibly functional and has continually empowered most people just like me to achieve their dreams. Your amazing insightful information entails much to me and especially to my peers. Thanks a ton; from all of us. Facboook
    by mtom on Aug 08, 2022
  65. Thanks it was helpful - it worked on Excel 2016
    by Ranjit on Nov 06, 2022
  66. Thank a lot!
    by Double "A" on Nov 25, 2022
  67. Thank you very, very much! This method really works following your step-by-step instruction.
    by Mr. Krishna Yadav on Mar 15, 2023
  68. thank you so much, this was very helpful
    by Snorria Kumpasa on Apr 04, 2023

Contact Us!

Main Library: (330) 490-7185
Main Library: (330) 490-7185

Questions? Ask Us!

Related Topics