@Risk Error: "The correlation matrix at .... specifies an invalid column."

Check your `RiskCorrmat()` functions for 0, empty cells, or invalid column references; also avoid naming a matrix `Corrmat`, which can cause conflicts.

Dec 11, 2025
Knowledge

Title

Answer

Applies to: @RISK for Excel 3.5 and Up

Error:

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

Cause:

There is a RiskCorrmat( ) function in the Excel model that specifies the invalid column.

Solution:

Review your RiskCorrmat( ) functions and check whether any use 0, an empty cell reference, or another invalid entry for the matrix column (the second argument). These will trigger errors.

Another possible cause is naming a correlation matrix Corrmat, which creates a name conflict within the model.

URL Name

the-correlation-matrix-at-specifies-an-invalid-column

@Risk Error: "The correlation matrix at .... specifies an invalid column."

Information

Related Articles

Trending Articles