Load Solver Add In. In the Add-Ins available box select the Solver Add-in check box and then click OK. Go to the file button and click on options Go to Add-Ins and click on the Go Button Choose the Solver Add-in and click OK if you click OK and it asks for disks you need to speak to your IT department You will see the Solver button in the Data Ribbon right at the end.
The same with Excels Analysis ToolPak you have to load the tool before you can use it. To save the model reopen the Solver add-in. To use the Solver Add-in however you first need to load it in Excel.
In the Add-ins window press the checkbox next to.
To load the solver add-in execute the following steps. To save the model reopen the Solver add-in. Then click Options at the bottom of the left-hand sidebar. To use the Solver Add-in however you first need to load it in Excel.