My spreadsheet has two scenarios in it and was working correctly several
weeks ago. Now, the problem is that when I run the scenario summary, the
results are the same for both scenarios.

You can edit the Scenarios, to return the changing cells to their
original values:

Select the sheet that contains the scenarios
Choose ToolsScenarios
Select a scenario from the list
Click Edit
Click OK
Change the values, click OK
Click Close

Elizabeth wrote:
My spreadsheet has two scenarios in it and was working correctly several
weeks ago. Now, the problem is that when I run the scenario summary, the
results are the same for both scenarios.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Thank you for replying. :) I re-entered the values, but the scenario summary
still gives the scenario that I have selected to be "shown" three times: Once
in the current value column and then in both the scenario columns.

I am using Excel 2002.

Do you have any other suggestions?

"Debra Dalgleish" wrote:

You can edit the Scenarios, to return the changing cells to their
original values:

Select the sheet that contains the scenarios
Choose ToolsScenarios
Select a scenario from the list
Click Edit
Click OK
Change the values, click OK
Click Close

Elizabeth wrote:
My spreadsheet has two scenarios in it and was working correctly several
weeks ago. Now, the problem is that when I run the scenario summary, the
results are the same for both scenarios.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Did you rerun the Scenario Summary after you changed the values? It
doesn't update to reflect changes to the scenarios.

Elizabeth wrote:
Thank you for replying. :) I re-entered the values, but the scenario summary
still gives the scenario that I have selected to be "shown" three times: Once
in the current value column and then in both the scenario columns.

I am using Excel 2002.

Do you have any other suggestions?

"Debra Dalgleish" wrote:


You can edit the Scenarios, to return the changing cells to their
original values:

Select the sheet that contains the scenarios
Choose ToolsScenarios
Select a scenario from the list
Click Edit
Click OK
Change the values, click OK
Click Close

Elizabeth wrote:

My spreadsheet has two scenarios in it and was working correctly several
weeks ago. Now, the problem is that when I run the scenario summary, the
results are the same for both scenarios.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Yes, I re-ran the scenario summary report.

"Debra Dalgleish" wrote:

Did you rerun the Scenario Summary after you changed the values? It
doesn't update to reflect changes to the scenarios.

Elizabeth wrote:
Thank you for replying. :) I re-entered the values, but the scenario summary
still gives the scenario that I have selected to be "shown" three times: Once
in the current value column and then in both the scenario columns.

I am using Excel 2002.

Do you have any other suggestions?

"Debra Dalgleish" wrote:


You can edit the Scenarios, to return the changing cells to their
original values:

Select the sheet that contains the scenarios
Choose ToolsScenarios
Select a scenario from the list
Click Edit
Click OK
Change the values, click OK
Click Close

Elizabeth wrote:

My spreadsheet has two scenarios in it and was working correctly several
weeks ago. Now, the problem is that when I run the scenario summary, the
results are the same for both scenarios.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

I found one other message in the Google newsgroup archives that
describes a similar problem, but no solution was posted:


http://groups.google.ca/group/micros...68296a70c35f4c

What names did you use for the Scenarios?

If you'd like to send me the file, I can take a look at it.

Elizabeth wrote:
Yes, I re-ran the scenario summary report.

"Debra Dalgleish" wrote:


Did you rerun the Scenario Summary after you changed the values? It
doesn't update to reflect changes to the scenarios.

Elizabeth wrote:

Thank you for replying. :) I re-entered the values, but the scenario summary
still gives the scenario that I have selected to be "shown" three times: Once
in the current value column and then in both the scenario columns.

I am using Excel 2002.

Do you have any other suggestions?

"Debra Dalgleish" wrote:



You can edit the Scenarios, to return the changing cells to their
original values:

Select the sheet that contains the scenarios
Choose ToolsScenarios
Select a scenario from the list
Click Edit
Click OK
Change the values, click OK
Click Close

Elizabeth wrote:


My spreadsheet has two scenarios in it and was working correctly several
weeks ago. Now, the problem is that when I run the scenario summary, the
results are the same for both scenarios.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html




--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html





--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html