Create an Excel Scenario Summary
Unfortunately, both types of summary report are static, and they don’t update if the Scenario data changes. If you create a Scenario Summary, be sure to date stamp it, or delete it before saving the workbook. You don’t want to keep potentially misleading data in your files.
And the Scenario Summary formatting is about as ugly as Excel gets – purple and grey. Maybe they’ll improve that in the next version! (But don’t hold your breath.)
Watch the Video
To see the steps for creating Scenario Summary, please watch this short video tutorial. This video includes a tip for adding the Scenario command in the Excel 2010 Ribbon, so it is easy to switch between Scenarios.