I am running a Probability Sensitivity Analysis (PSA) with multiple iterations starting from 10.
The values are not reflecting any changes i make in the model.
Are you using AMPL (https://ampl.com)? If so, you have come to the right place. To get some help, however, you will need to give a more detailed explanation of how AMPL is being used, and how it fits in with your VBA program. Also, it will be helpful to attach all of the files involved in your application.
Note that AMPL’s “read table” and “write table” statements cannot read or write a spreadsheet file while it is open in Excel.