Excel Data Analysis Toolpak not loading

Anonymous
2022-11-28T15:49:06+00:00

The data analysis toolpak is checked but still not showing up. I went to repair it through appwiz but microsoft office isn't even showing up in my downloaded programs yet i have access to everything else still so plz help!

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 No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Anonymous
    2022-11-29T02:50:36+00:00

    Dear T_Spamp,

    Greetings! Thank you for posting in Microsoft forum.

    I understand you tried repairing Office, but Microsoft 365 apps were not listed in the installed apps on your computer. The command appwiz will open Control Panel (Control Panel\Programs\Programs and Features). Please note, if Microsoft 365 isn't listed in the Control Panel you could have a Microsoft Store installation type.

    To confirm which type of Microsoft 365 apps are installed on your computer, please follow the steps below:

    1. Open any Office app such as Word.
    2. Create or open an existing file and select File > Account (or it might say Office Account).
    3. Under Product information, find the About button and check for the following, check whether it include the phrase Click-to-Run or Microsoft Store.

    Office apps saying “Microsoft Store” will not appear in Control Panel, it will appear under Apps and Features instead **(**Right-click the Start button (lower-left corner) and select Apps and Features on the pop-up menu). For detailed information, see Repair an Office application - Microsoft Support

    Besides, please provide us with the following information so we can understand the scenario and provide information accordingly:

    1. Please provide the screenshot of Microsoft 365 Product Information. To get this screenshot, open Word or Excel on your system, click File>Account, capture the screenshot of all the information mentioned under Product Information.
    2. In Excel, click File > Options > Add-Ins. At the bottom of the dialog box, change the Manage dropdown to Excel add-ins, and select Go, check if you see Analysis ToolPak. If so, check the box, click OK and verify if it becomes available under Data tab as shown below.

    If you need help, let me know, I will help you further. Stay safe and stay healthy.

    Sincerely,

    Neha Singh | Microsoft Community Moderator

    0 comments No comments