Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing scenarios
Hello.....
I did post this question a few days ago but didn't get a reply so I'm really hoping somebody can help me...... I have created 3 scenarios, all containing details of various bank loans, interest rates etc. I have produced the scenario summary 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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing scenarios
Check Tools==Options==Calculations==Automatic (is checked).
"Louise" wrote: Hello..... I did post this question a few days ago but didn't get a reply so I'm really hoping somebody can help me...... I have created 3 scenarios, all containing details of various bank loans, interest rates etc. I have produced the scenario summary 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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Editing scenarios
Yes it is checked. I don't have a problem with any of my other formulae,
just editing scenarios. Louise "Toppers" wrote: Check Tools==Options==Calculations==Automatic (is checked). "Louise" wrote: Hello..... I did post this question a few days ago but didn't get a reply so I'm really hoping somebody can help me...... I have created 3 scenarios, all containing details of various bank loans, interest rates etc. I have produced the scenario summary 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating and editing scenarios | Excel Worksheet Functions | |||
.xls is locked for editing. Really strange. | Excel Discussion (Misc queries) | |||
Merging Scenarios | Excel Discussion (Misc queries) | |||
Using a formulae within scenarios | Excel Discussion (Misc queries) | |||
File is locked for Editing by user problem | Excel Discussion (Misc queries) |