I'm using self-referencing in Excel to change scenarios. How do I
force Excel to recalculate the two scenarios? I tried creating a dummy
table that would plug in the two different scenario #'s into the
selected scenario, but doesn't seem to work.

You can achieve your objective using the Scenarios feature within MS
Excel. A scenario is a set of values that MS Excel saves and can
substitute automatically in your worksheet.

You can create and save different groups of values on a worksheet and
then switch to any of these new scenarios to view different results.

There is an excellent article on Excel Scenarios at Tech Republic
(http://techrepublic.com.com/5100-6270-1040562.html)

Look for 'Scenarios' under the 'Tools' menu.

Kind regards,
FatherTed-ga

---

Request for Answer Clarification by adam4321-ga on 30 Apr 2004 07:00 PDT

This unfortunately won't work---I'm trying to set up output tables
that can automatically update themselves when other variables change.
The Excel Scenario feature is static.

Thanks,
Adam

---

Clarification of Answer by fatherted-ga on 30 Apr 2004 08:40 PDT

Sorry I can't be of further assistance - please reject the earlier answer.

Regards
FatherTed-ga

---

Request for Answer Clarification by adam4321-ga on 30 Apr 2004 12:32 PDT

No problem. How do I reject your answer?

Thanks,
Adam

Normally in excel you would press shift + f9 to recalculate.

But I guess that's not your question.  Can you give more detail ?

No, it's for self-referencing cells:

i.e.

Cell A9 might be:
=IF(Scenario=1,SomeResultCell,A9)

And Cell A20 might be:
=IF(Scenario=2,SomeResultCell,A20)

Right now, I have to manually set Scenario=1, then hit F9, then set
Scenario=2, then hit F9 again. I wrote a macro to do this, but would
like a way to automatically do it. I was hoping setting up a table
that cycled the cell named "Scenario" to 1,2,3,etc. would do this, but
it didn't seem to work.