haalift.blogg.se

OPEN2 = "C:\Program Files\Microsoft Office\Office12\Library\SOLVER\SOLVER. HKEY_CURRENT_USER\Software\Microsoft\Office\12.0\Excel\Options Once you find the above registry key let’s change it toĥ. OPEN2 = /F "C:\Program Files\Microsoft Office\Office12\Library\SOLVER\SOLVER.XLAM

How to back up and restore the registry in WindowsĤ. Then, you can restore the registry if a problem occurs.įor more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base: For added protection, back up the registry before you modify it. Therefore, make sure that you follow these steps carefully. Note that you must already invoke or activate Solver if Solver is not on the Data tab, refer to the Help file (Solver) for instructions. However, serious problems might occur if you modify the registry incorrectly. Click SOLVE to run the Excels Solver add-in and obtain the optimized solution. Important: - This section, method, or task contains steps that tell you how to modify the registry. In the Convergence box, type the amount of relative change that you want to allow in the last five iterations before Solver stops with the message Solver converged to the current solution. In the Solver Options dialog box, on the GRG Nonlinear tab, choose one or more of the following options: Convergence.

Try following steps to change the registry key to resolve this issue:- In the Solver Parameters dialog box, click Options.