Scenario data

[marstongould]

I know that Excel can store up to as many scenarios as you have memory
for - but is there a way to access the data across scenarios all at
the same time?

Trying to create a single file for forecasting - each scenario would
represent the results from a specific time period, but it would be
nice to make comparisons across scenarios easily.

 

[Bob Umlas, Excel MVP]

In the Scenario manager dialog, there's a button for producing a Summary and
you can do a simple summary or a pivot table summary