![]() |
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. |
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. |
All times are GMT +1. The time now is 01:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com