Scenarios limitation

[kuansheng]

Hi I was trying to create scenario but i came across the tutorial on
contextures saying excel has a limitation of only 32 changing cell. Is
there anyway to increase the number of changing cell, or is there ways
to go about doing this.

Thanks.

 

[Guest]

Perhaps you could try something like this:

Put the first 32 changing cells in Scenario 1a
Put the second 32 changing cells in Scenario 1b
etc


Does that help?

***********
Regards,
Ron

XL2002, WinXP-Pro

 

[Debra Dalgleish]

Another option is to use the alternative method shown in the sample file
here:

http://www.contextures.com/excelfiles.html

Under Scenarios, look for 'Alternative to Scenario'