HomeTroubleshooting@RISK for Excel: Simulation"The cell ... is part of an array formula."

4.45. "The cell ... is part of an array formula."

Applies to:
@RISK 5.x–7.x
RISKOptimizer 5.x

When I run my simulation, a message pops up saying

The cell ... is part of an array formula. @RISK outputs cannot be part of array formulas.

Or

The cell ... is part of an array formula. @RISK distributions cannot be part of array formulas.

When I click OK, the simulation is abandoned. What is wrong, and how can I fix it?

To speed up the calculations, at start of simulation @RISK replaces formulas that include RiskOutput( ) and other @RISK functions with special formulas; then at the end of simulation is resets them to the formulas that you entered. @RISK can't do this replacement with an array formula, and therefore you get this message.

Exceptions: RiskData( ) can be used effectively in array formulas; see Placing Iteration Data in Worksheet with RiskData( ). Also, @RISK's Time Series Fit and Batch Fit commands create the time series distributions as array formulas.

There are two workarounds:

Last edited: 2015-10-15

This page was: Helpful | Not Helpful