Office Compatibility Issues

Troubleshoot Excel Solver Models After an Office 365 Update

Huda QurayshiHuda Qurayshi Nov 18, 2026 870 views

Question details

Identify why an Excel model that worked with an earlier Solver add-in version is unsolvable after an Office 365 update.

Troubleshoot Excel Solver Models 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.
Before you start

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.

Solution 1Recommended

Compare the Solver model and settings

Use this approach to find differences in the model setup that may explain the changed result.

1
Open Solver parameters

In Excel, open the affected workbook and select Data > Solver. If possible, open the same workbook in the earlier Excel installation as well.

2
Check the model references

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.

3
Compare constraints and method

Review each entry under Subject to the Constraints and compare the selected solving method, such as Simplex LP, GRG Nonlinear, or Evolutionary.

4
Review Solver options

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.

5
Run the model again

Select Solve after correcting any unintended differences. Record the result message and the settings used if the model still cannot be solved.

Compare the Solver model and settings
Settings may vary: Solver options and dialog labels can differ by version and solving method. Matching the settings does not guarantee identical results.
Free Microsoft Office alternative

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.

Open and edit compatible Microsoft Excel XLS and XLSX filesReview model inputs, formulas, and worksheet data in WPS SpreadsheetsUse a familiar interface for a smoother move from Microsoft OfficeAccess a free, lightweight office suite
microsoft office alternative - wps office

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.