View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Coderre
 
Posts: n/a
Default 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.