Showing scenarios

<< Click to Display Table of Contents >>

Showing scenarios

If you have created scenarios as described in the previous section, you can display them at any time:

Proceed as follows:

1.Choose the ribbon command Data | group Analyze | Scenario manager scenario_manager_icon.
2.In the dialog box, select the scenario to be displayed from the Scenarios list.
3.Click on the Show button.

Tip: You can do so even quicker if you simply double-click on the scenario in the list.

The selected scenario will then be displayed.

By switching between different scenarios, you can now compare how changing the cells specified in the scenario affects the calculations that refer to those cells.

Note: When you display a scenario, the values in the specified "changing cells" are physically replaced by the values set in the scenario. The old cell contents will thus be lost.