#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Scenario data

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.

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
What if scenario Andrey Excel Discussion (Misc queries) 0 January 4th 07 03:38 PM
scenario/what if ?? MikeR-Oz New Users to Excel 2 November 24th 06 11:33 AM
About Data Table & Scenario Manager. JOBY JOHN NEERIYANKAL Excel Worksheet Functions 0 July 19th 06 03:30 PM
Scenario? simmerdown Excel Worksheet Functions 6 January 25th 06 10:05 PM
IF Scenario will.00 Excel Worksheet Functions 1 June 15th 05 10:38 AM


All times are GMT +1. The time now is 02:49 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"