Scenarios limitation
 

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.

Scenarios limitation
 

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


"kuansheng" wrote:

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.

Scenarios limitation
 

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

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

Under Scenarios, look for 'Alternative to Scenario'

kuansheng wrote:
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.



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html