Scenarios

[David]

Hi Group,

I am using Version 2003. I am in "Microsoft Excel Data Analysis & Business
Modeling," pg 138, where I am trying to do a Scenario. In the example
Tools/Scenarios/Add I set the changing cells. In the book, the "labels" for
the changing cells show up, but when I do it only the Cell addresses show up.
There are only three things that are changing, "Yr 1 Sales," "Sales Growth
Rate," and Yr 1 Selling Price". These "labels" showup in the book and in the
example, but when I try and recreate the example I get $C$2, $C$3 and $C$4,
not the "labes" or "descriptions."

Maybe there is a parameter in Options I need to change? I tried selecting
the labels also, but that did not work, Excel thinks I want to change those
cells.

Thanks,

 

[David]

Figured it out, has named ranges.

 

[Debra Dalgleish]

If the value cells are named, the names will show up in the Scenario
Summary. There's an example here:

http://www.contextures.com/xlScenario01.html