Contact

Microsoft Excel · Analysis and charts · Intermediate

Compare saved assumptions with Scenario Manager in Excel

Compare saved assumptions with Scenario Manager in Excel with a complete practice example, expected results and recovery checks.

Official documentation reviewed; example logic independently checked; native Excel execution not performed · Editorial standards

Quick answer: Save each input set in Data → What-If Analysis → Scenario Manager, then use Show to switch the assumptions feeding one formula model. A scenario summary is a snapshot; regenerate it after changing a saved scenario.

Version and platform: Microsoft 365 Excel for Windows desktop; Mac, Excel for the web and Excel 2013 interfaces not covered. Use a disposable workbook for the exercise.

Prepare a two-input model

In a blank worksheet put Revenue in A2, Cost in A3 and Surplus in A4. Enter 1000 in B2, 600 in B3 and =B2-B3 in B4. The starting surplus is 400. Save a practice XLSX copy before adding scenarios.

Use B2:B3 as the changing cells. B4 must remain a formula and must not be included among the changing inputs. The three planned sets are:

Scenario Revenue Cost Expected surplus
Base 1000 600 400
Lower revenue 800 650 150
Higher revenue 1300 700 600

These are saved assumptions, not probabilities or predictions. Scenario Manager applies values you supply; it does not determine which scenario will happen.

Save all three scenarios

Select B2:B3, choose Data → What-If Analysis → Scenario Manager, then Add. Enter Base as the name and verify the Changing cells are $B$2:$B$3. Confirm, review the values 1000 and 600 in the values dialog, and finish adding the scenario.

Add Lower revenue with the same changing cells and values 800 and 650. Add Higher revenue with values 1300 and 700. Keep the order aligned with the displayed cell references; swapping revenue and cost produces a plausible-looking but inverted calculation. For this practice workbook, do not rely on scenario protection options to protect the whole workbook. Microsoft notes those scenario flags act only when the worksheet is protected.

Show and compare the saved sets

In Scenario Manager select Lower revenue and choose Show. Inspect the actual worksheet: B2 should be 800, B3 should be 650 and B4 should be 150. Show Higher revenue and expect 1300, 700 and 600. Show Base and expect 1000, 600 and 400.

Showing a scenario changes the input cells in the live worksheet; it is not just a preview panel. Do not leave a scenario selected accidentally in a workbook whose displayed result someone else may treat as the current plan. Choose deliberately which input set should remain visible before saving or distributing a result.

Create and refresh a comparison snapshot

Use Scenario Manager’s Summary command, choose a Scenario summary, and specify B4 as the result cell. The report should compare the two input cells and the formula result for each saved scenario. Its Current Values column reflects the worksheet inputs at report creation, not a fourth saved scenario. Creating names for inputs before reporting can make labels clearer, but it is not required for this small exercise.

Now edit the saved Lower revenue scenario in Scenario Manager so Revenue is 850 and Cost remains 650. Show it and expect 200. Inspect the earlier summary: it should not be treated as an automatically refreshed report. Create a new summary and check the revised 850, 650 and 200 alongside the unchanged Base and Higher revenue values. Label or remove obsolete practice summaries so you do not confuse the two snapshots.

Save and troubleshoot

Show Base before saving the final XLSX. Reopen it, inspect B4=400, then show the revised Lower revenue scenario and confirm 200. If B4 changes to a typed value, it was probably included in Changing cells; repair the model and scenario definitions. If the report still says 150, check whether you are looking at the old summary. Scenarios allow up to 32 changing cells each, but this focused example needs only two. Goal Seek answers the reverse question of which input reaches a target; it does not replace these saved assumption sets.

Official references

Documentation snapshots retrieved 20 October 2026. These instructions and example checks are documentation-based; no native Excel run or application screenshot is claimed.