Forum home » Delegate support and help forum » Microsoft Excel Training and help » Scenario Summary

Scenario Summary

ResolvedVersion 2010

Tue 28 Jan 2014, 16:45 Delegate David said...

David has attended:
Outlook Advanced course

Scenario Summary

Is there a limit to the number of scenario summaries per workbook (i.e. more than one). A number of users crashed when inserting a 2nd one.

Tue 28 Jan 2014, 16:47 Trainer Gary said...

RE: Scenario Summary

Hi David

Thanks for getting in touch. Microsoft's resource for Excel limits state that:

"Limited by available memory; a summary report shows only the first 251 scenarios"

So theoretically no although your computer will stop working before then.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Tue 4 Feb 2014: Automatically marked as resolved.

Training courses

98.7 % recommend us

More live stats...

Training information:

Excel tip:

Generating Random Numbers

To generate a random number in Excel use the = RAND() function.

The value returned will always be between 0 and 1. To convert this to some other random value, you will need to multiply the result by the highest number you want to consider. For example, if you wanted a random number between 1 and 25, you could use the following code line:
= INT(25 * RAND()+ 1)

Since RAND() will always returns a value between 0 and 1 (but never 1 itself), multiplying what it returns by 25 and then using the Integer function INT on that result will return a whole number between 0 and 24.

Finally, 1 is added to this result, so that x will be equal to a number between 1 and 25, inclusive

View all Excel hints and tips

Scenario Summary

Scenario Summary

RE: Scenario Summary

Excel articles

Excel tip:

Generating Random Numbers