Question

About invalid matrix with 3-Examples


don't spam ❌❌❌​

Answer 1

Invalid matrix location" when Defining Correlations. ... This can happen when you define a correlation matrix in @RISK and then delete it in Excel, or in some scenarios when you delete worksheets or move worksheets between workbooks.

Answer 2

Answer:

Invalid matrix location" when Defining Correlations8.39. "Invalid matrix location" when Defining Correlations.

In Excel, click Formulas » Name Manager. You probably have one or more names pointing to #REF. This can happen when you define a correlation matrix in @RISK and then delete it in Excel, or in some scenarios when you delete worksheets or move worksheets between workbooks.To solve the problem, delete all the names that point to #REF. You will then be able to define your correlation matrix.To prevent the problem from recurring, don't delete correlation matrices in Excel. Instead, use the Delete Matrix button in the Define Correlations dialog. That will not only delete the matrix, but also delete the name in Name Manager and remove the references to the matrix from the @RISK distributions.

Step-by-step explanation:

Hope this may help you.....

☬Tanvi☬

✌️ Follow me ✌️