scenario summary

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

Scenario Summary

resolvedResolved · Medium Priority · Version 2010

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.

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.


 

Excel tip:

Quickly Adding New Worksheets

Want to place a new Excel worksheet before current worksheet. Use keystroke SHIFT+F11

View all Excel hints and tips


Server loaded in 0.07 secs.