Home

EXCEL CHANGES DATA AFTER SCENARIO IS SHOWN

%3CLINGO-SUB%20id%3D%22lingo-sub-95618%22%20slang%3D%22en-US%22%3EEXCEL%20CHANGES%20DATA%20AFTER%20SCENARIO%20IS%20SHOWN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-95618%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20readers!%3CBR%20%2F%3E%3CBR%20%2F%3EMicrosoft%20Excel%20changes%20the%20data%20on%20one's%20spreadsheet%20permanently%20after%20one%20creates%20a%20scenario%20and%20shows%20it.%20How%20can%20the%20spreadsheet%20not%20be%20changed%20permanently%20after%20showing%20a%20scenario%3F%3CBR%20%2F%3E%3CBR%20%2F%3EI%20am%20currently%20using%20Microsoft%20Excel%202010%20to%20learn%20Excel%20(using%20a%20teaching%20facility%20computer)%3A%20help%20would%20be%20much%20appreciated.%3CBR%20%2F%3E%3CBR%20%2F%3ESincerely%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-95618%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Desktop%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENeed%20Help%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EScenario%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EScenario%20Manager%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ETip%20and%20Tricks%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EWhat-if%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-251477%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20CHANGES%20DATA%20AFTER%20SCENARIO%20IS%20SHOWN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-251477%22%20slang%3D%22en-US%22%3E%3CP%3EI%20realise%20this%20is%20an%20old%20thread%20but%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20using%20the%20Excel%20built%20in%20Scenario%20Manager%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20a%20thought%3A%20what%20did%20you%20expect%20Excel%20to%20do%20after%20you%20had%20created%20a%20scenario%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESecondly%2C%20are%20you%20aware%20that%20you%20can%20select%20each%20an%20every%20scenario%20you%20create%20so%20that%20you%20can%20go%20back%20to%20your%20original%20data%20at%20any%20time.%20Or%20you%20can%20stay%20with%20the%20scenario%20that%20you%20prefer.%20In%20case%20you%20don't%20know%2C%20do%20this%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EData%20tab%3C%2FP%3E%3CP%3EWhat%20if%20Analysis%26nbsp%3Bin%20Forecast%3C%2FP%3E%3CP%3EScenario%20Manager%3C%2FP%3E%3CP%3EUnder%20the%20heading%20Scenarios%3A%20you%20will%20see%20the%20names%20of%20the%20scenarios%20you%20have%20created%2C%20click%20the%20name%20of%20the%20one%20you%20want%20to%20put%20back%20into%20memory%20then%20click%20Show%20at%20the%20bottom%20...%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAll%20of%20your%20data%20in%20your%20scenario%20model%20will%20now%20be%20changed%20to%20your%20newly%20chosen%20scenario!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-95915%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20CHANGES%20DATA%20AFTER%20SCENARIO%20IS%20SHOWN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-95915%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20Detlef%20Lewin%3CBR%20%2F%3E%3CBR%20%2F%3EAfter%20finding%20out%20what%20RAND()%20and%20RANDBETWEEN()%20was%2C%20I%20can%20confirm%20no%20such%20function%20was%20used%3A%20I%20did%20not%20ask%20my%20initial%20question%20out%20of%20wanting%20attention.%3CBR%20%2F%3E%3CBR%20%2F%3EI%20hope%26nbsp%3Byou%20leave%20conversation%20threads%20of%20people%20you%20assume%20are%20wanting%20attention.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-95634%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20CHANGES%20DATA%20AFTER%20SCENARIO%20IS%20SHOWN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-95634%22%20slang%3D%22en-US%22%3E%3CP%3EV.K.%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eif%20your%20knowledge%20is%20that%20less%20it%20would%20be%20wise%20to%20consult%20a%20tutor%20who%20teaches%20you%20face%20to%20face.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FRAND-function-4cbfa695-8869-4788-8d90-021ea9f5be73%3FCorrelationId%3D8fea5cad-a63d-4ad2-9a93-a2177038bfac%26amp%3Bui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ERAND()%3C%2FA%3E%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FRANDBETWEEN-function-4cc7f0d1-87dc-4eb7-987f-a469ab381685%3FCorrelationId%3Da29145d9-c4bb-465f-863a-77539091e52e%26amp%3Bui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%26amp%3BocmsassetID%3DHA102752890%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3ERANDBETWEEN()%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-95632%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20CHANGES%20DATA%20AFTER%20SCENARIO%20IS%20SHOWN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-95632%22%20slang%3D%22en-US%22%3EIt%20would%20be%20helpful%20if%20you%20elaborated%20to%20this%20individual%20who%20is%20nowhere%20need%20an%20expert%20when%20it%20comes%20to%20computing%20-%20what%20is%20RAND()%20or%20RANDBETWEEN()%20%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-95630%22%20slang%3D%22en-US%22%3ERe%3A%20EXCEL%20CHANGES%20DATA%20AFTER%20SCENARIO%20IS%20SHOWN%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-95630%22%20slang%3D%22en-US%22%3E%3CP%3EV.K.%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Emaybe%20your%20spreadsheet%20uses%20RAND()%20or%20RANDBETWEEN()%20in%20formulas.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
V. K.
New Contributor

Hello readers!

Microsoft Excel changes the data on one's spreadsheet permanently after one creates a scenario and shows it. How can the spreadsheet not be changed permanently after showing a scenario?

I am currently using Microsoft Excel 2010 to learn Excel (using a teaching facility computer): help would be much appreciated.

Sincerely,

5 Replies
Highlighted

V.K.,

 

maybe your spreadsheet uses RAND() or RANDBETWEEN() in formulas.

 

It would be helpful if you elaborated to this individual who is nowhere need an expert when it comes to computing - what is RAND() or RANDBETWEEN() ?

V.K.,

 

if your knowledge is that less it would be wise to consult a tutor who teaches you face to face.

RAND()

RANDBETWEEN()

 

Hello Detlef Lewin

After finding out what RAND() and RANDBETWEEN() was, I can confirm no such function was used: I did not ask my initial question out of wanting attention.

I hope you leave conversation threads of people you assume are wanting attention.

I realise this is an old thread but ...

 

Are you using the Excel built in Scenario Manager?

 

Just a thought: what did you expect Excel to do after you had created a scenario?

 

Secondly, are you aware that you can select each an every scenario you create so that you can go back to your original data at any time. Or you can stay with the scenario that you prefer. In case you don't know, do this:

 

Data tab

What if Analysis in Forecast

Scenario Manager

Under the heading Scenarios: you will see the names of the scenarios you have created, click the name of the one you want to put back into memory then click Show at the bottom ...

 

All of your data in your scenario model will now be changed to your newly chosen scenario!