Troubleshoot Microsoft Excel Solver Results That Are Not Saved
Question details
The user needs to determine why Excel Solver briefly displays a solution, then restores the initial values and reports that no solution can be found.

- Product
- Microsoft Excel Solver add-in
- Device & OS
- not provided
- Scenario
- Running Solver to optimize a workbook model and retain the resulting values.
- Observed behavior
- Solver temporarily displays candidate values, but they are not retained, and the run ends with a message that no solution can be found.
Open the affected workbook and locate Data > Solver to review the objective, changing cells, and constraints. Use File > Save As to create a separate test copy before changing the model or Solver settings.
Check whether the displayed values satisfy the Solver model
Use this first when Solver briefly shows an apparent answer but reports that it cannot find a solution.
Values displayed during a Solver run are trial values, not necessarily a feasible solution. A plausible objective value does not prove that every constraint has been satisfied.
Open Data > Solver. Confirm that Set Objective points to the intended formula cell, that Max, Min, or Value Of matches your goal, and that By Changing Variable Cells contains the intended input cells.
In the Solver Parameters dialog, select each constraint and click Change to inspect its cell references, comparison operator, and limit. Check for contradictory bounds, incorrect ranges, and unintended integer or binary restrictions.
Select the objective and constraint formula cells and inspect the formula bar. Correct errors such as #DIV/0! or #VALUE!, and confirm that changing the designated input cells actually changes the relevant formulas.
In the test copy, open Data > Solver and temporarily remove or relax a suspected conflicting constraint, then click Solve. Compare the outcome to identify which restriction prevents a feasible result.

Match the Solver method and limits to the workbook model
Use this when the model appears feasible but Solver stops early, behaves inconsistently, or uses an unsuitable solving method.
Keep a valid Solver solution and save the workbook
Use this after Solver returns an acceptable result and you want the calculated input values retained.
Review Excel Model Data in WPS Spreadsheet
WPS Office is a free, lightweight alternative for opening and reviewing Excel workbooks in a familiar spreadsheet interface. Excel format compatibility makes migration straightforward for everyday spreadsheet work, but WPS does not repair Microsoft Excel Solver or guarantee equivalent Solver add-in behavior.

Frequently Asked Questions
Why does Solver show an answer and then say no solution was found?
Solver can display trial values while searching. Those values may improve the objective without satisfying every constraint. Open Data > Solver and check all constraints and formula dependencies before treating a displayed answer as a solution.
How do I stop Solver from restoring the original values?
After an acceptable run, select Keep Solver Solution in the Solver Results dialog and click OK. Then save the workbook with File > Save. If Solver reports an infeasible model, diagnose the constraints before retaining the candidate values.
Will increasing iterations fix a Solver run that fails?
It may help if Solver stopped because it reached its iteration limit. Open Data > Solver > Options to review the limit. Increasing iterations will not fix contradictory constraints, invalid formulas, or incorrectly defined changing cells.
Which Solver method should I use?
Choose the method under Data > Solver > Select a Solving Method. Simplex LP suits linear models, GRG Nonlinear suits smooth nonlinear models, and Evolutionary is useful for nonsmooth or discontinuous models.
Can WPS Office fix Microsoft Excel Solver results?
No. WPS Office does not repair the Microsoft Excel Solver add-in. You can open an Excel workbook in WPS Spreadsheet to review inputs, formulas, and saved values, but use Excel Solver to troubleshoot and rerun the original optimization model.




