ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Creating and editing scenarios (https://www.excelbanter.com/excel-worksheet-functions/110010-creating-editing-scenarios.html)

Louise

Creating and editing scenarios
 
Hi all

I have created 3 scenarios, all containing details of various bank loans,
interest rates etc.

I have produced the scenario report and it worked fine, however, I have now
gone to one of the scenarios and changed some of the figures. When I then
reproduce the scenario report, it doesn't take into account the new figures I
have entered, it still runs on the old ones, even though I saved the workbook.

How do I tell Excel that the details for Scenario Two, for example, have
changed and that the report should therefore show these?? I'm obviously
missing out a vital step but i don't know where........

Thank you.
Louise


All times are GMT +1. The time now is 02:21 AM.

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