Thread: Scenario data
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Umlas, Excel MVP Bob Umlas, Excel MVP is offline
external usenet poster
 
Posts: 320
Default Scenario data

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

" wrote:

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.