You could also look at the Scenario Alternative sample file he

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

Under Scenarios, look for 'SC0002 - Alternative to Scenario'

Gerry wrote:
Hi,

I am trying to solve the following issue:

My excel workbook includes two kind of input values:

1) Assumptions (I am using a Scenario PivotTable Report to track the effect
of different assumption sets on the "result cell");
2) Background data (Its values also affect the "result cell" and they are
changing time to time. I can not create scenarios for every background data
cell, as there are too many of them).

Every time background data change (quite often), I must rebuild Scenario
PivotTable Report, as it does not take into account the updated values.

Is there any quick way to refresh a Scenario PivotTable Report?

Thanks in advance,

Gerry


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html