Troubleshoot Excel Solver Models After an Office 365 Update
Question details
Identify why an Excel model that worked with an earlier Solver add-in version is unsolvable after an Office 365 update.

- Product
- Microsoft Excel for Microsoft 365 Solver add-in
- Device & OS
- not provided
- Scenario
- A user runs an existing optimization model after an Office update installs a newer Solver version.
- Observed behavior
- The model previously worked with Solver but is reported as unsolvable with the newer version.
Open the affected workbook and note the Solver result message. If you have access to the earlier version, open the same model there so you can compare its settings.
Compare the Solver model and settings
Use this approach to find differences in the model setup that may explain the changed result.
In Excel, open the affected workbook and select Data > Solver. If possible, open the same workbook in the earlier Excel installation as well.
In the Solver Parameters dialog, compare the Set Objective cell, the Max, Min, or Value Of selection, and the By Changing Variable Cells range between versions.
Review each entry under Subject to the Constraints and compare the selected solving method, such as Simplex LP, GRG Nonlinear, or Evolutionary.
Select Options in the Solver dialog and compare the available precision and convergence settings. Also check the worksheet formulas and input values referenced by the model.
Select Solve after correcting any unintended differences. Record the result message and the settings used if the model still cannot be solved.

Report the compatibility issue or investigate a rollback
Use this option if the model remains unsolvable after the settings are checked.
Work with Excel spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files to continue everyday spreadsheet work, though WPS Office does not fix Microsoft Excel Solver compatibility issues.

Frequently Asked Questions
Where can I find the Solver settings in Excel?
Open the workbook and select Data > Solver. The Solver Parameters dialog shows the objective cell, variable cells, constraints, and solving method; select Options to review additional settings.
Why does Solver say a previously working model is unsolvable?
The model's inputs, formulas, constraints, solving method, or precision settings may differ, or the newer version may behave differently. Compare the setup in Data > Solver and record the exact result message.
Can I reinstall only the previous Solver version?
Not necessarily. The built-in Solver add-in is generally managed with Office. Ask your Microsoft 365 administrator or Microsoft support whether a supported Office rollback is available for your installation.
What should I include in a Solver support request?
Include the Excel version and build, the Solver result message, objective and variable cell references, constraints, solving method, and relevant options. Share a workbook example if you have permission to do so.




