[Fixed!] Data Analysis Not Showing in Excel: 2 Effective Solutions

Method 1 – Unchecked Analysis ToolPak Add-in Option Results in Data Analysis Not Showing in Excel

Steps:

  • Go to the File tab.

Data Analysis Not Showing in Excel

  • Select Options.

  • Click Add-ins.
  • Choose either Excel Add-ins or COM Add-ins. I chose the Excel Add-ins option, Data Analysis toolpak is within this.
  • Press on Go.

Data Analysis Not Showing in ExcelData Analysis Not Showing in Excel

  • Check one Add-in at a time and press OK.

  • Go to the Data tab to verify the Data Analysis option.

Data Analysis Not Showing in Excel


Method 2 – Data Analysis Not Showing in Excel Due to Add-ins Issue in Trust Center Command

Steps:

  • Click on the File tab.

  • Select Options.

Data Analysis Not Showing in Excel

  • Pick the Trust Center option.
  • Click on Trust Center Settings.

  • Go to Add-ins.
  • Check the box named Required Application Add-ins to be signed by Trusted Publisher and press OK.

Data Analysis Not Showing in Excel

  • Click OK again to finish the process.

  • You can go to the Data tab to check the Data Analysis option whether it is showing or not.

Data Analysis Not Showing in Excel

 


Related Articles


<< Go Back to Data Analysis with Excel Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Naimul Hasan Arif
Naimul Hasan Arif

Naimul Hasan Arif, a BUET graduate in Naval Architecture and Marine Engineering, has been contributing to the ExcelDemy project for nearly two years. Currently serving as an Excel and VBA Content Developer, Arif has written more than 120 articles and has also provided user support through comments His expertise lies in Microsoft Office Suite, VBA and he thrives on learning new aspects of data analysis. Arif's dedication to the ExcelDemy project is reflected in his consistent contributions and... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo