HomeTroubleshooting@RISK for Excel: Simulation"The correlation matrix at .... specifies an invalid column."

4.50. "The correlation matrix at .... specifies an invalid column."

Applies to: @RISK for Excel 3.5 and newer

When I try to run my model, which contains the @RISK correlation matrix created through the Model window, upon clicking the Run Simulation button, I get this message:

The correlation matrix at '[workbook]worksheet'!range specifies an invalid column (0).

There is a RiskCorrmat( ) function somewhere in the Excel model that specifies the invalid column. The error is in the RiskCorrmat( ), not in the matrix referenced in the error message. Look through the RiskCorrmat( ) functions for one or more that specify a zero, a reference to an empty cell, etc. for the matrix column (the second argument to RiskCorrmat).

Another cause (in @RISK 3.5 and 4.x) is having a correlation matrix named Corrmat, which causes a name conflict within the model.

Last edited: 2012-01-18

This page was: Helpful | Not Helpful