Forum Discussion

TaquyiaC's avatar
TaquyiaC
Copper Contributor
Jul 14, 2024

School assignment

I'm supposed to load a analysis toolpak on to my Excel. I don't know if I am doing something wrong. Please help me figure out if I have loaded it or what I am doing wrong.

 

Desperately 

Taquyia Carter 

  • TaquyiaC 

    Analysis ToolPak is for the desktop version of Excel for Windows and Mac. It does not work in Excel Online.

    For example in Excel for Windows:

    • Select File > Options.
    • Select Add-ins. You should see something similar to this:
    • As you can see, Analysis ToolPak is currently listed under 'Inactive Application Add-ins' on my PC.
    • To activate it, click on Go... near the bottom of the dialog:
    • Tick the check box for 'Analysis ToolPak', then click OK.
    • You should now have new group on the right-hand side of the Data tab of the ribbon, Analysis, with one item: Data Analysis. Click that to start Analysis ToolPak.

Resources