Forum Discussion

vinayak23's avatar
vinayak23
Copper Contributor
Sep 07, 2022
Solved

Analysis toolpak VBA for mac

How can I add analysis toolpak VBA for excel in mac? I am currently running on excel 16.64
excel
Macros and VBA
  • NikolinoDE's avatar
    NikolinoDE
    Sep 07, 2022

    vinayak23 

    Load the Analysis ToolPak in Excel for Mac

     

    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.

NikolinoDE's avatar
NikolinoDE
Gold Contributor
Sep 07, 2022

vinayak23 

Load the Analysis ToolPak in Excel for Mac

 

  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