Forum Discussion

Erin1220's avatar
Erin1220
Copper Contributor
Sep 08, 2023

Excel add ins

Hello,   I am trying to add load the analysis toolpak in excel but I can't figure out how to add that and I can't seem to search for anything new. I follow the steps my teacher assigned but it isn'...
excel
HansVogelaar's avatar
HansVogelaar
MVP
Sep 08, 2023

Erin1220 

What platform are you on? (Windows, MacOS, ...)

Which version of Office/Excel do you have?

Dunni500's avatar
Dunni500
Copper Contributor
Sep 09, 2023
Hello Hans,

I am also having similar challenge. I need to use the Analysis Toolpak on MacOS but the function is not available in my excel. Are you able to help
  • HansVogelaar's avatar
    HansVogelaar
    MVP
    Sep 09, 2023

    Dunni500 

    For the desktop version of Excel for Mac, Load the Analysis ToolPak in Excel suggests:

     

    1. Click the Tools menu, and then click Excel Add-ins.

    2. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.

      1. If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.

      2. If you get a prompt that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.

      3. Quit and restart Excel.

        Now the Data Analysis command is available on the Data tab.

     

Resources