Senisitvity Analysis

[saadferoze]

While running sensitivity analysis, i am getting the same result for all different scenarios. I am using data tables for this and one of my input parameter is linked figure which is calculated from other sheets. What could be the problem.


Regards

Saad

 

[Hui]

Saad

I suspect that you have either:

Enabled Calculation Except Data Table, Change Calculation to Automatic

or

You have entered the cell Reference as a Column where it should be Row or vice-versa

 

[saadferoze]

Great Hui, you were on spot. that was the reason, its working now.


Thanks

Saad