Scenario Manager
 

Hello,

I'm working with the scenario manager in Excel and I have a couple of
questions, I hope some one can help me with:
- can the scenarios be entered in a different way than via the scenario
manager input menu, I mean, is it possible to refer to a workbook?!
- can the order of scenarios be changed?
- I have worked on this sheet on different computers; with different
language settings... Meaning that half of the scenarios do not work on any of
both computeres, since there are dots and comma's, any suggestion?! (CTRL-H
does not work here, since the values are entered in the menu, they do not
refer to a workbook)

I would realy appreciate help on this, thanks a lot!

Max

Scenario Manager
 

"Max" wrote:

Hello,

I'm working with the scenario manager in Excel and I have a couple of
questions, I hope some one can help me with:
- can the scenarios be entered in a different way than via the scenario
manager input menu, I mean, is it possible to refer to a workbook?!
- can the order of scenarios be changed?
- I have worked on this sheet on different computers; with different
language settings... Meaning that half of the scenarios do not work on any of
both computeres, since there are dots and comma's, any suggestion?! (CTRL-H
does not work here, since the values are entered in the menu, they do not
refer to a workbook)

I would realy appreciate help on this, thanks a lot!

Max

Scenario Manager
 

"Max" wrote:

Hello,

I'm working with the scenario manager in Excel and I have a couple of
questions, I hope some one can help me with:
- can the scenarios be entered in a different way than via the scenario
manager input menu, I mean, is it possible to refer to a workbook?!
- can the order of scenarios be changed?
- I have worked on this sheet on different computers; with different
language settings... Meaning that half of the scenarios do not work on any of
both computeres, since there are dots and comma's, any suggestion?! (CTRL-H
does not work here, since the values are entered in the menu, they do not
refer to a workbook)

I would realy appreciate help on this, thanks a lot!

Max

Hello Max,
You could try recording a macro while entering values for a
scenario.This will give you the skeleton of VBA Code to set scenarios. Once
you know the syntax of the code you can edit this recorded macro and put in
variables to refer to the workbook and the values you enter in the scenario
mgr's input box.
I hope this clue will solve your problem.

VIJAY