Microsoft Office Tutorials and References
In Depth Information
Adding, editing, and deleting scenarios
Adding, editing, and deleting scenarios
Excel saves scenarios with all other data when you save the workbook. Each worksheet in
a workbook can contain its own set of scenarios. In the Scenario Manager dialog box, you
add new scenarios by clicking Add, and you edit existing scenarios by clicking Edit, which
displays the Edit Scenario dialog box (which is functionally the same as the Add Scenario
dialog box shown in Figure 18-9). You can change the name of the selected scenario, add
or remove changing cells, or add comments in the Edit Scenario dialog box.
Tracking changes
If someone edits a scenario, Excel adds a Modified By entry to the Comment box in the
Scenario Manager dialog box, beneath the Created By entry that appears when you first
add a scenario. Each time a scenario is modified, Excel adds the name of the user and the
date of modification. This information is particularly helpful if you route your what-if
models to others and then merge their scenarios into a single what-if model, as discussed in the
following section.
INSIDE OUT Comment modifications
When you edit scenarios, you can modify the contents of the Comment box; those
modifications persist in all dialog boxes, including the creation and modification dates.
You might not want to permit users to modify the comments if you really want to track
changes or prevent tampering. If you don’t want these comments modified, make sure
you take advantage of the preventative measures discussed in “Protecting worksheets”
in Chapter 6, “How to work a worksheet.”
Routing and merging scenarios
If part of your job is to develop what-if models or projections for your company, you
probably spend a lot of time gathering information about trends and market forces that might
affect the company in the future. Often, you need input from several people, each of whom
knows about a particular aspect of the business, such as payroll costs or sales trends. Excel
includes a scenario-merging feature to make this sort of information gathering easier.
For example, suppose you want to distribute a what-if model to your coworkers: Vicki has
expertise about customer trends, Max knows the payroll story, and Regina keeps track of
advertising. You can distribute individually named copies of the workbook to each
person, and after your coworkers add their what-if scenarios and return the workbook or
workbooks, you can merge the scenarios into a master worksheet. Simply open all the
Search JabSto ::

Custom Search