Sep 07 2022 03:01 AM
How can I add analysis toolpak VBA for excel in mac? I am currently running on excel 16.64
Sep 07 2022 03:13 AM
SolutionLoad 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.
Sep 07 2022 03:13 AM
SolutionLoad 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.