Yes. After Solver finds a solution in Excel for Microsoft 365 on Windows, choose Save Scenario in the Solver Results dialog, give the scenario a name, and confirm. Excel stores the solution’s changing-cell values in Scenario Manager, where you can show or compare them later; it does not save the entire Solver setup as a scenario.
What saving a Solver scenario means
Solver searches for values in selected worksheet cells that optimize an objective, subject to any constraints you set. For example, it might find production quantities that maximize profit while staying within labor and material limits. Those selected cells are called the changing cells, or variable cells.
When you save a scenario from Solver’s results, Excel creates a Scenario Manager entry containing the values Solver found for those changing cells. You can later apply those values to the worksheet without running Solver again. Formulas that depend on the changing cells recalculate, so you can inspect the resulting totals, profit, or other outputs.
A scenario is therefore a saved set of inputs, not a frozen copy of the workbook or a record of every Solver decision. It is useful when you want to keep a solution, compare alternatives, or return to a particular set of inputs after testing other values.
Check the workbook before solving
Solver is an Excel desktop add-in. In Windows Excel, if the Solver command is missing, enable it through File > Options > Add-ins. At the bottom, set Manage to Excel Add-ins, choose Go, select Solver Add-in, and click OK. The command should then appear under Data > Solver.
On a Mac, the add-in is enabled from Tools > Excel Add-ins; select Solver Add-in, then look for Solver on the Data tab. The precise dialog layout can vary slightly by Excel release. Solver is a desktop feature, so do not expect to run the Solver add-in in Excel for the web; open the workbook in desktop Excel to solve and save a scenario.
Before solving, identify the cells that Solver is allowed to change and make sure the worksheet formulas represent the result you want to optimize. Save the workbook before a major analysis, especially if you are experimenting with several models or constraints.
How to save a Solver solution as a scenario
- On the worksheet, open Data > Solver and set the objective cell, the cells Solver may change, and any required constraints.
- Choose Solve. Wait for Solver to finish and review the status in the Solver Results dialog.
- If the proposed solution is one you want to keep, choose Keep Solver Solution. This leaves the solved values in the worksheet. Choosing Restore Original Values instead returns the changing cells to their earlier values.
- In the same results dialog, choose Save Scenario. Type a descriptive name, such as Best margin with overtime, and confirm. Excel adds the values of the changing cells to Scenario Manager.
- Return to the worksheet or Solver dialog when finished. To inspect the saved entry later, open Data > What-If Analysis > Scenario Manager.
The order matters in practice: decide whether to keep the solution, and save the scenario from the results dialog before dismissing it. If you close the results dialog without saving, you can still save the current cell values manually in Scenario Manager, but the dedicated Solver Results option is the direct route.
What the scenario saves—and what it does not
Scenario Manager saves values for the changing cells specified by Solver. It does not preserve the objective-cell selection, Solver method, constraints, or the full configuration of the Solver Parameters dialog as part of that scenario. The workbook’s formulas remain formulas; they recalculate when a scenario is shown.
That distinction helps avoid a common misunderstanding: saving a Solver scenario is not the same as saving the Solver model. If you need to reproduce the optimization itself, preserve the Solver settings as well as the scenario. Solver’s Parameters dialog includes a Load/Save option for storing a model definition in a worksheet range. The workbook and that saved model range should be retained together.
Scenario Manager also has a limit of 32 changing cells per scenario. If a Solver model uses more than 32 variable cells, the scenario route may not be suitable for saving all of them. In that case, preserve a copy of the workbook or record the solved values in a separate worksheet, and keep the Solver model settings independently.
Show, compare, and report saved scenarios
Open Data > What-If Analysis > Scenario Manager to see the scenarios stored in the workbook. Select one and choose Show to put its saved changing-cell values back into the worksheet. Excel recalculates dependent formulas using those values. Showing a scenario changes the current worksheet inputs, so save or document any unsaved work before switching if those current values matter.
For a side-by-side comparison, use Summary in Scenario Manager. Excel asks for result cells: select the formula cells whose outcomes you want to compare, such as total cost, revenue, or unused capacity. The resulting Scenario Summary report presents the scenarios’ changing values and the selected results. It is a report for comparison, not a new Solver run, and it does not replace the original worksheet or model.
Choose result cells that are meaningful formulas, rather than simply selecting every cell in the model. For instance, if a production model has three product quantities as changing cells, a total-profit formula and a total-hours formula can make the trade-off clearer than the quantities alone.
Example: keep alternative production plans
Imagine a worksheet with quantities for three products in changing cells, a profit formula as the Solver objective, and constraints for available labor and materials. Solver finds one combination that produces the highest profit under those limits. Saving that result as Max profit records the three quantities in Scenario Manager.
You might then adjust a constraint or change the objective to explore a second plan. If Solver finds a solution that uses less overtime, save it separately as Lower overtime. The two scenarios let you restore either set of quantities and compare the resulting profit, hours, or material usage. They do not contain two different versions of the constraint settings; record those settings separately if you need to explain exactly how each plan was generated.
This is particularly helpful when a decision-maker wants to review options without repeatedly solving the model. It is also important to label scenarios clearly. Names such as Plan A and Plan B are less informative than names that describe the assumptions or purpose, such as Max profit or No weekend shift.
Common problems and practical fixes
- There is no Save Scenario button. Confirm that you are looking at the Solver Results dialog after a solve, rather than the Solver Parameters dialog. If Solver did not produce a usable solution or you have already closed the results dialog, use Scenario Manager to create a scenario from the current changing-cell values.
- Solver is missing from the Data tab. Enable the Solver Add-in using the Windows or Mac steps above. If a managed work computer blocks add-ins, ask the organization’s support team about its Excel configuration.
- The scenario does not restore the whole model. That is expected: it restores changing-cell values, not formulas, Solver constraints, or a copy of the workbook. Keep a separate saved Solver model and a clearly documented workbook if reproducibility matters.
- Scenario Manager cannot accept all variable cells. Check whether the model exceeds the 32-changing-cell scenario limit. Save a workbook copy or record the complete solution elsewhere rather than assuming a partial scenario is equivalent.
- Showing a scenario seems to overwrite current inputs. Showing is meant to apply the saved values to the changing cells. Save the current workbook state first, or save its current values as another scenario if you want to switch back easily.
Frequently Asked Questions
Does Excel Solver save a scenario automatically?
No. You need to choose Save Scenario in the Solver Results dialog and provide a name. A solution left in the worksheet is not, by itself, a named Scenario Manager entry.
Where do I find a saved Solver scenario?
Go to Data > What-If Analysis > Scenario Manager. Select a scenario and choose Show to apply its saved changing-cell values.
Can I save multiple Solver solutions?
Yes. Save each solution under a different name in Scenario Manager, subject to its 32-changing-cell limit per scenario. Clear names make it easier to identify the assumptions or purpose of each option.
Does a saved scenario include Solver constraints?
No. The scenario stores changing-cell values. Preserve the Solver model settings separately if you need to rerun the same optimization with the same objective and constraints.
Can I use a saved scenario without running Solver again?
Yes. Choose the scenario in Scenario Manager and select Show. Excel applies its saved input values and recalculates worksheet formulas, but it does not search for a new optimum.
Can I create a Scenario Summary report?
Yes. In Scenario Manager, choose Summary and identify the result cells to compare. Excel creates a report showing the selected outputs for the scenarios; it does not rerun Solver or capture the full Solver setup.
Related
- Excel Slicer Horizontal: How to Arrange Buttons in Rows
- Excel Slicer Multiple Columns: What Works and What Doesn’t
- Excel Slicer Multiple Selections: How to Use Them
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How Excel Goal Seek Works: Steps, Examples, and LimitsExcel Goal Seek works backward from a formula result: you specify the result you want, and Excel adjusts…
- Excel Shortcut to Select to the Bottom of a ColumnIn Excel for Microsoft 365 on Windows, press Ctrl+Shift+Down Arrow to extend a selection from the active cell…
- How to Alphabetize in Google Sheets Without Mixing RowsTo alphabetize data in Google Sheets, select the full range you want to sort, then choose Data >…
- Goal Seek in Google Sheets: Find a Target Value FastGoogle Sheets does not offer a built-in Goal Seek command like Excel, but you can use a Goal…
- Markdown Merge Cells: What Works and What Does NotNo: standard Markdown tables do not support merged cells. If your Markdown renderer allows HTML, you may be…
- How to Find Hidden Tabs in ExcelTo find a hidden worksheet in Excel for Microsoft 365 on Windows, right-click any visible sheet tab, choose…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.