On a Mac, this window will open after clicking Excel Add-ins in the Tools menu. 7 Install the Solver add-in. Check the 'Solver' box in the middle of the page, then click OK. Installing Solvers on Excel for Mac 2016. If you are running Excel 2016 on Mac, you need to install the solvers after unzipping OpenSolver. Inside the unzipped folder, go to Solvers/osx you will find a file called “OpenSolver Solvers.pkg”. Open this file and click through the prompt to set up the solvers on your computer (you will need to enter the administrator password to do so).
Solver was added to Microsoft Office for Mac 2011 in Service Pack 1. You can download and install Office for Mac 2011’s Service Pack 1 by clicking on the link below:
When you have installed Service Pack 1 (SP1), follow these steps to start Solver:
a. Start Excel. b. Click Tools -> Select Add-Ins. c. Click to select the check box for Solver.Xlam. d. Click OK.
The Data Analysis Toolpak was removed in Mac:Office for Mac 2008. However, you can download a free third-party tool that offers similar functionality:
Is there a way to record a macro that
copy data from a 'data' sheet to a 'calculator' sheet
activate the 'SOLVER' function
goes to a 'result' sheet
copy result and paste into 'data' sheet
then loops
I tried recording these but the problem I faced was that the macro didn't give SOLVER enough time to finish the iterations needed to get a solution.
One very slow way I could think of was to get macro to do everything from step 3 to step 5 and then step 1 and ends, then I manually start the solver and wait for the iterations to complete. Anyone can help me? Sorry I'm super newbie here