This tutorial shows how to solve the problem that data analysis does not show up in Excel. That is, you click the “Data” tap, but you can not see find “Data Analysis” module.
![Data analysis not show up in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-11-1-1024x118.png)
Steps of fixing “Data Analysis” not show up in Excel
Step 1: Click “File” and “Options”
Click “File” on the top and then click “Options.”
![Step 1 of solving data analysis not show up in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-12-1.png)
Step 2: Click “Add-ins”
Click “Add-ins” as the second step of solving data analysis module not showing up in Excel
![Step 2 of solving data analysis not show up in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-13-1.png)
Step 3: Click “Analysis ToolPak”
Click “Analysis ToolPak“, as shown below in the figure.
![Step 3 of solving data analysis not show up in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-14-1.png)
Step 4: Click “Go”
You need to click “Go” as shown below.
![Step 4 of solving data analysis not show up in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-15-1.png)
Step 5: Select “Analysis ToolPak” and then click “OK”
In this step, you need to first select “Analysis ToolPak” and then click “OK.”
![Step 5 of solving data analysis not show up in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-16-1.png)
After step 5, you should be able to see “Data Analysis” appears under the menu of “Data.”
!["Data Analysis" appears under the menu of "Data" in Excel](https://tidystat.com/wp-content/uploads/2023/01/image-17-1-1024x111.png)