Share via

Data analysis disappeared.

Anonymous
2023-03-12T18:28:55+00:00

I'm trying to get the data analysis tool back into my excel sheet. I've added it before but for some reason it won't come back. I tried adding in the analysis add-in (Might I add I tried both) and nothing happens. It just adds analyze data, but I need data analysis. I checked for updates and restarted my computer, but I can't figure out what's going on.

Microsoft 365 and Office | Excel | For education | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-03-13T03:22:54+00:00

    Dear LillianBez,

    Good day! Thank you for posting to Microsoft Community. We are happy to help you.

    Data Analysis will be available by enabling the Analysis ToolPak add-in in the Excel application and Analysis ToolPak add-in is a default add-in the Excel app, where enabling it will make Data Analysis available in the Data tab of the Excel app:

    So, I would like to suggest you to see whether the Analysis ToolPak add-in is enabled in the Excel app. If yes, please disable and re-enable it to see the outcome.

    Open the Excel app> Options> Add-ins> Excel Add-ins> Click on Go

    If still the same problem persists, please check whether the Excel app is up to date? Open the Excel app> Account> Update Options> Update Now.

    If it's updated and still have the same issue, please perform Online Repair to the Office apps and check the outcome. Reference: Repair an Office application - Microsoft Support

    Thanks for your cooperation and patience.

    Sincerely,

    Mia | Microsoft Community Moderator

    4 people found this answer helpful.
    0 comments
  2. Anonymous
    2023-03-16T07:32:11+00:00

    Dear LillianBez,

    I'm writing this to follow up your thread, May I know if the above information we provided can be useful for the missing Data Analysis situation? Do feel free to post back if it still needs any further assistance or guide on this scenario, we'll continue to help you all the time.

    Besides, if you think this is helpful, please kindly submit the feedback, this will help the other users on the community to see it more clearly.

    Really appreciate your patience and understanding.

    Sincerely,

    Mia | Microsoft Community Moderator

    0 comments