SOLVED

Analysis toolpak VBA for mac

Occasional Visitor

How can I add analysis toolpak VBA for excel in mac? I am currently running on excel 16.64

1 Reply
best response confirmed by JimGMac (MVP)
Solution

@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.