Forum Discussion
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
Load the Analysis ToolPak in Excel for Mac
Click the Tools menu, and then click Excel Add-ins.
In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.
If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.
If you get a prompt that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
Quit and restart Excel.
Now the Data Analysis command is available on the Data tab.
Load the Analysis ToolPak in Excel for Mac
Click the Tools menu, and then click Excel Add-ins.
In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK.
If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it.
If you get a prompt that the Analysis ToolPak is not currently installed on your computer, click Yes to install it.
Quit and restart Excel.
Now the Data Analysis command is available on the Data tab.
