LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 217
Default 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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I lock some fields but allow editing for others in excel S.Sharif Excel Discussion (Misc queries) 1 December 13th 05 02:58 AM
How can I protect a worksheet yet allow editing in Excel 2000 jimar Excel Discussion (Misc queries) 1 August 26th 05 11:25 AM
Editing the name box TDS570 New Users to Excel 2 August 7th 05 06:12 PM
Question from MOS file E03C-1-1 , Creating data and contents Dora Excel Discussion (Misc queries) 1 June 5th 05 08:51 AM
Excel Creating Temporary File After Saving NicIT Excel Discussion (Misc queries) 1 February 14th 05 01:47 AM


All times are GMT +1. The time now is 08:51 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"