How to Stop Solver in Excel Without Losing Your Work

To stop a Solver run in Excel for Microsoft 365 on Windows, click Stop in the Solver Status window. When Solver presents its results, choose Restore Original Values to undo its changes to the variable cells, or Keep Solver Solution to leave the current values in place. Save a copy of important work first: stopping a run does not necessarily restore the worksheet automatically.

What You’ll Need

Excel desktop for Windows with the Solver Add-in enabled. Solver is not available to run in Excel for the web; open the workbook in the desktop app instead.
A workbook with a Solver model, including the objective cell, variable cells, and any constraints you set.
If the current cell values matter, a saved copy of the workbook or a note of those values before solving.

Solver searches for values that optimize a target cell while obeying the limits in its model. It may change the worksheet’s variable cells as it works. Knowing what those cells were before the run helps you decide whether to keep the values Solver reached or restore the starting values after stopping.

Step-by-Step

Start Solver from the desktop app. Open the workbook and select Data > Solver. If Solver is not shown on the Data tab, enable the add-in first: select File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins, select Go, check Solver Add-in, and select OK. Return to the Data tab and open Solver.
Check the model before you run it. In Solver Parameters, confirm the objective cell, whether you are maximizing, minimizing, or setting a value, the changing variable cells, and any constraints. This is useful if you are stopping because Solver is taking too long or appears to be solving the wrong problem.
Choose Solve. Select Solve in Solver Parameters to begin. Excel opens a Solver Status window while the Solver engine searches. Depending on the model and its settings, the window may show progress or status information. A complicated model can take time, so do not assume the application has frozen simply because the numbers have not changed immediately.
Click Stop in the Solver Status window. When you want to interrupt the run, select the window’s Stop button. This asks Solver to end its search; it does not mean the worksheet has been restored to its pre-run state. If the window is behind another window, bring it to the front using the taskbar or window switcher and look for the Solver Status dialog.
Wait for Solver to finish stopping. Give Excel a moment to respond, especially if the model is large or the workbook is calculating many formulas. Avoid clicking Solve repeatedly or opening another copy of the workbook while the first run is active. Repeated actions can make it harder to tell which run or workbook you are controlling.
Choose what to do with the values. After the run stops, read the Solver Results dialog and select Restore Original Values if you want the variable cells returned to their values from just before the run. Choose Keep Solver Solution if you want to retain the values currently in those cells. If Solver stopped before finding an optimal solution, keeping the values does not make them an optimal answer; check the status message and validate the result yourself.
Close the results dialog and inspect the worksheet. Check the changing cells, the objective cell, and any formulas that depend on them. If you restored the original values, verify that they match your saved notes or copy. If you kept the solution, check whether the constraints are satisfied and whether the result is useful for your purpose.
Decide whether to retain Solver’s model settings. Stopping a run does not usually mean you need to delete the model. If you want to revise it, open Data > Solver, adjust the parameters, and solve again. If you only wanted to close the Solver Parameters window before starting a run, select Cancel; that is different from stopping a search already in progress.

The key distinction is between stopping Solver’s search and undoing its worksheet changes. The Stop button interrupts the search; the choice in Solver Results determines whether the variable-cell values reached during that run remain or the pre-run values are restored. Formulas, formatting, and unrelated worksheet content are not a substitute for a saved backup, so save a copy if the workbook is important.

Common Mistakes

Closing the wrong window. Solver Parameters appears before a run, while Solver Status appears during a run. Use Stop in the status window to interrupt an active search. Closing Solver Parameters before solving simply closes the setup dialog; it cannot stop a run that has not started.
Assuming Stop means undo. Stopping the search and restoring the changing cells are separate actions. Read the Solver Results options and choose Restore Original Values if that is what you need.
Keeping a partial result as if Solver had finished. A run stopped by the user may not have found a solution or met all constraints. A plausible-looking objective value alone does not confirm that the answer is valid.
Using Ctrl+Z as the recovery plan. Do not rely on Undo to reverse Solver’s changes. The results dialog offers a clearer choice, and a saved copy gives you a dependable fallback if you need to recover the workbook.
Removing the add-in to stop one run. Disabling Solver is unnecessary for interrupting a search and can make Solver disappear from the Data tab. Use the Stop button for an active run; change the add-in setting only if you intentionally want to disable Solver.

Tips

Save a checkpoint first. Use File > Save As to make a separate copy before running a model you are still developing. A copy preserves the starting workbook even if you accidentally keep a partial result or change other cells afterward.
Record the variable cells. If there are only a few changing cells, note their original values or copy them to a temporary area before solving. This is especially helpful when comparing a starting scenario with a candidate result.
Check the model rather than repeatedly stopping and restarting. Confirm that the target formula depends on the changing cells and that the constraints describe the actual limits. A missing link or incorrect constraint can make Solver seem unproductive even though the real issue is the setup.
Use a small test when developing a large model. Try the setup on a copy or a reduced example first. This can help reveal incorrect cell references and unnecessary complexity before you run the full workbook.
Keep the status message in context. If you stop because Solver reports no feasible solution or another issue, note that message before closing the dialog. It can point to a model problem that simply stopping will not fix.
Know the platform difference. These instructions describe Excel for Microsoft 365 on Windows. Solver is a desktop add-in, not a feature you can run in Excel for the web. On Mac, Solver is also accessed from the Data tab when its add-in is enabled, but dialog layouts and the path for enabling add-ins can differ from Windows. Follow the Stop and results choices shown by the Mac dialog.

Troubleshooting

I cannot find a Stop button. Make sure you are looking at the Solver Status window, not the Solver Parameters window or the worksheet. Use the taskbar or window switcher to bring the status dialog forward. If no search is currently running, there will not be an active run to stop.

Excel appears unresponsive. Give it time to calculate before taking further action; large models can temporarily make the interface slow. Avoid ending the Excel process unless it has clearly stopped responding and you accept the risk of losing unsaved changes. If you must close Excel, reopen the saved copy and inspect it rather than assuming the interrupted run was safely rolled back.

Solver is not on the Data tab. In Windows desktop Excel, enable it through File > Options > Add-ins, then choose Excel Add-ins beside Manage and select Go. Check Solver Add-in and select OK. If you are in Excel for the web, open the file in desktop Excel; the web app does not run this Solver add-in.

The values changed after I stopped Solver. Reopen the results dialog if it is still available and choose Restore Original Values. If you already dismissed it or continued editing, use your saved copy or manually restore the recorded starting values. Do not assume that closing the workbook without saving will recover the right version if AutoSave or other changes are involved.

The result is not acceptable, but Solver says it found a solution. Review the objective, changing cells, and constraints in Solver Parameters, then inspect the worksheet formulas. A solution can be mathematically valid for the model you entered but not match the real-world question you intended. Correct the setup and run Solver again on a saved copy.

I want to stop Solver from being available in Excel. That is an add-in setting, not a way to interrupt a current search. First stop any active run and close the results dialog. Then, in Windows, open File > Options > Add-ins, choose Excel Add-ins in Manage, select Go, clear Solver Add-in, and select OK. You can enable it again using the same route.

Frequently Asked Questions

Does clicking Stop cancel the Solver run immediately?
It requests that Solver stop searching. Excel may need a short time to respond, particularly with a large or calculation-heavy workbook. Wait for the results or status dialog before taking another action.

Will Stop return my worksheet to its original values?
Not by itself. In Solver Results, select Restore Original Values to return the changing cells to their values from just before that run. Choose Keep Solver Solution to leave the current values in place.

Can I stop Solver with Esc or Ctrl+Break?
Use the visible Stop button in Solver Status as the dependable method. Keyboard interruption behavior can vary with the dialog and Excel state, so do not rely on Esc or Ctrl+Break as a replacement for the button.

Can I stop Solver in Excel for the web?
No. Excel for the web does not run the desktop Solver Add-in. Open the workbook in desktop Excel to use Solver and its Stop control.

Does stopping Solver erase my constraints?
Stopping a run does not normally remove the model settings. Open Data > Solver to review or change them. Avoid choosing a reset option unless you intend to clear the Solver setup.

Can I keep a result even if I stopped the search early?
Yes, you can choose Keep Solver Solution in the results dialog, but treat the values as a candidate rather than a confirmed optimum. Check the status message, objective, and constraints before relying on them.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.