Remove @RISK Functions

In some cases it may be necessary to share a model with other users who do not have @RISK installed, nor do they have access to a machine with Excel and @RISK. If a workbook that contains an @RISK model is opened by a user who does not have @RISK installed, any cells that contain an @RISK function will return errors. In these scenarios it is possible to remove all @RISK functions from a model so that the results of a simulation can be shared with others, without the need to install @RISK.

The @RISK command Swap-Out @RISK is the preferred method of preparing a workbook for sharing with users who do not have @RISK installed. See Swap-Out @RISK for more information.

The Remove @RISK Functions command will remove functions from ALL OPEN WORKBOOKS!

It is highly recommended that a copy of the @RISK model is made BEFORE removing all @RISK functions!

The remove command results are:

  • All Inputs (distributions and time series models) and Statistical Functions will be replaced with the static or expected values of the @RISK function.
  • All Outputs will have the RiskOutput function removed; any other formula and cell references will remain.
  • All Correlations and Copula functions will be removed with the associated Input functions; the tables containing the correlation coefficients or copula data will remain.
  • All Simulation data stored in the workbook will be removed.
  • All Graphs inserted into any worksheet will remain.