ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   excel 2003 scenario manager (https://www.excelbanter.com/excel-discussion-misc-queries/231734-excel-2003-scenario-manager.html)

CathyH

excel 2003 scenario manager
 
does a scenario summary report update automatically if the scenarios are
changed? if a new scenario is added, is it added to the current summary
report? or do you have to create a new scenario summary whenever the
scenarios are changed?



Debra Dalgleish

excel 2003 scenario manager
 
The Scenario Summary report is static, and shows the values at the time
you created it.

If you change the scenarios, you can create a new summary, and either
delete the old one, or leave it as historical data.

cathyh wrote:
does a scenario summary report update automatically if the scenarios are
changed? if a new scenario is added, is it added to the current summary
report? or do you have to create a new scenario summary whenever the
scenarios are changed?


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com



All times are GMT +1. The time now is 08:43 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com