Knowledge base

The RiskAMP add-in uses spreadsheet functions to provide random distributions and statistical analysis.

If you create a model using RiskAMP functions and then open it on a manchine that doesn’t have the add-in installed, these functions won’t be available. This will cause #NAME errors in the spreadsheet.

In the Professional edition of the add-in, we provide a function to remove all RiskAMP spreadsheet functions and replace them with static values. Once you do that, you can open the file on any machine and the model will stay consistent.

To lock simulation functions, click the button in the Monte Carlo toolbar.

Locking simulation functions is reversible, so if you have the add-in installed you can restore locked functions.