T
tm_1
When I run a summary using the scenario manager in my model the outputs do
not vary. It appears this is because Excel chooses not to recalculate the
workbook during the scenario run (if i run the scenario manager with the
calaculation mode set to automatic rather than manual the outputs do vary).
This is annoying if you have a large model with iterative calcs which you
prefer to run on manual calculation.
Does anyone know a way round this? Or indeed if I've got this wrong?
not vary. It appears this is because Excel chooses not to recalculate the
workbook during the scenario run (if i run the scenario manager with the
calaculation mode set to automatic rather than manual the outputs do vary).
This is annoying if you have a large model with iterative calcs which you
prefer to run on manual calculation.
Does anyone know a way round this? Or indeed if I've got this wrong?