Scenarios limitation

K

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.
 
R

Ron Coderre

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
 
Top