Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am trying to use Scenario Manager to run 3 different scenarios with
multiple variables. Each time that I try to add the "change cells", the program crashes. Any ideas? Any info is much appreciated. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Can you provide some more information?
What happens if you run only one scenario? What version of Excel are you using? What operating system version are you using? How much RAM does your computer have? Answers to any of these questions might point you in the right direction. Dave -- Brevity is the soul of wit. "Antonia M. Lafferty" wrote: I am trying to use Scenario Manager to run 3 different scenarios with multiple variables. Each time that I try to add the "change cells", the program crashes. Any ideas? Any info is much appreciated. |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
It happens when trying to add the very first scenario. I suspect it has to
do with the number of cells that are permitted to change. Excel 2003 SP2 Window XP Pro 2002 SP2 Pentium 4 CPU 3.2 GHz 1.0 GB RAM "Dave F" wrote in message ... Can you provide some more information? What happens if you run only one scenario? What version of Excel are you using? What operating system version are you using? How much RAM does your computer have? Answers to any of these questions might point you in the right direction. Dave -- Brevity is the soul of wit. "Antonia M. Lafferty" wrote: I am trying to use Scenario Manager to run 3 different scenarios with multiple variables. Each time that I try to add the "change cells", the program crashes. Any ideas? Any info is much appreciated. |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Check this out: http://www.contextures.com/excelfiles.html#Scenarios
It says Scenarios are limited to 32 changing cells. -- Brevity is the soul of wit. "Antonia M. Lafferty" wrote: It happens when trying to add the very first scenario. I suspect it has to do with the number of cells that are permitted to change. Excel 2003 SP2 Window XP Pro 2002 SP2 Pentium 4 CPU 3.2 GHz 1.0 GB RAM "Dave F" wrote in message ... Can you provide some more information? What happens if you run only one scenario? What version of Excel are you using? What operating system version are you using? How much RAM does your computer have? Answers to any of these questions might point you in the right direction. Dave -- Brevity is the soul of wit. "Antonia M. Lafferty" wrote: I am trying to use Scenario Manager to run 3 different scenarios with multiple variables. Each time that I try to add the "change cells", the program crashes. Any ideas? Any info is much appreciated. |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Thanks for the help. This was my first time using a newsgroup. It proved
to be a worthwhile experience. "Dave F" wrote in message ... Check this out: http://www.contextures.com/excelfiles.html#Scenarios It says Scenarios are limited to 32 changing cells. -- Brevity is the soul of wit. "Antonia M. Lafferty" wrote: It happens when trying to add the very first scenario. I suspect it has to do with the number of cells that are permitted to change. Excel 2003 SP2 Window XP Pro 2002 SP2 Pentium 4 CPU 3.2 GHz 1.0 GB RAM "Dave F" wrote in message ... Can you provide some more information? What happens if you run only one scenario? What version of Excel are you using? What operating system version are you using? How much RAM does your computer have? Answers to any of these questions might point you in the right direction. Dave -- Brevity is the soul of wit. "Antonia M. Lafferty" wrote: I am trying to use Scenario Manager to run 3 different scenarios with multiple variables. Each time that I try to add the "change cells", the program crashes. Any ideas? Any info is much appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Scenario Manager | New Users to Excel | |||
Creating Scenarios and Scenario Manager | Excel Worksheet Functions | |||
why report manager ignores the range set in the scenario | Excel Discussion (Misc queries) | |||
Sumif Linking to Another Workbook error #VALUE! | Excel Discussion (Misc queries) |