I am doing this on a very standard pc with Vista. Right click on EXCEL.EXE< Properties< Compatibility< uncheck the box ‘Run this Program in Compatibility Mode’, Make sure you also click on the option 'change settings for all users' tab at the bottom of the same screen and click on Apply and Ok, open Excel and check if it works. In the Add-ins available box, select the Solver Add-in check box. In the Manage box, click Excel Add-ins, and then click Go. Click the File tab, click Options, and then click the Add-ins category. I know they sell more elaborate products than the standard Solver but I am just intersted in the standard Solver in Excel 2010. In Excel for Windows, if you don't see the Solver command or the Analysis group on the Data tab, you need to load the Solver add-in. If you are interested in any of our products, please don’t hesitate to contact us." "are a separate company from Microsoft and don’t handle technical questions for them. Chwirut1 dataset from StRD, American National Institute of Standard and Technology). I can of course provide examples of my problems (e.g. When I run Solver, it opens the solver window, states that it has results and then popups the following error message. It uses the very successful IPOPT non-linear solver. Of course I changed nothing else since I don't master the algorithms. I am trying to use Solver in 64-bit Excel 2010. Bonmin (Basic Open-source Nonlinear Mixed INteger programming) is an experimental open-source solver developed by COIN-OR that aims to solve mixed-integer non-linear problems, where the objective and constraints are twice continuously differentiable functions. Often Multistart provides the right solution but gives an error message and no answer reportĪnd the evolutionary method (also deselecting bounds) takes still more time but fails to progress from the initial point. Option for GRG2 (deselecting bounds since I have no bound) and the new evolutionary method take time but rarely provide better results than the default fast method. My first impression is that, provided I use automatic scaling and a much smaller convergence of 1.E-7, as recommended in previous studies, the default method gives good results. I have tried using standard examples of nonlinear fits (no bounds, relatively smoothįunctions) taken from the literature. I have been asked by the referees to include the new standard Excel Solver in my analysis. If you do not have Classic Menu for Office Click the Office Button in Microsoft Excel 2007, and click the File tab in Excel 2010/2013 Click the (Excel). In the Add-ins available list, check the box for Solver, and click OK. Upon clicking the Solve button, Solver then builds the optimization model from the data and. In the top right corner of Excel, click the X to quit Excel. This dialog (as it appears in Excel 2010) is shown in Figure 2. (A) In the Add-ins available list, uncheck the box for Solver, and click OK. I am writing a scientific article about the statistical improvements in Excel 2010. It appears you have the correct steps for File > Options > Add-Ins > Manage Excel Add-ins > Go.