Calculation Issues

Troubleshoot Microsoft Excel Solver Results That Are Not Saved

Natalie TaylorNatalie Taylor Nov 13, 2026 868 views

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.

Troubleshoot Microsoft Excel Solver Results That Are Not Saved
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.
Before you start

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.

Solution 1Recommended

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.

1
Verify the objective and changing cells

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.

2
Review every constraint

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.

3
Inspect formulas and dependencies

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.

4
Test feasibility separately

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.

Check whether the displayed values satisfy the Solver model
Do not treat a trial value as a valid solution: Relaxing a constraint can help diagnose the model, but the result is not valid for the original problem unless all original requirements are satisfied.
Free Microsoft Office alternative

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.

Open and edit Microsoft Excel .xlsx and .xls files.Review model inputs, worksheet formulas, and saved result values.Use a familiar spreadsheet interface for everyday workbook editing.Move routine spreadsheet tasks to a free, lightweight Office alternative.
microsoft office alternative - wps office

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.