Applies to:
@RISK 6.x/7.x

Error:

Cannot make a sheet to hold correlation information in protected workbook

Cause:

When you have correlations, @RISK has to pre-generate all the samples for the correlated distributions at the start of simulation, then rearrange them to achieve the desired correlation coefficients.

To do that, @RISK creates a worksheet in your workbook, and deletes that worksheet at the end of simulation.

If your workbook is protected through the Review » Protect Workbook method, @RISK cannot bypass the protection to create that worksheet.

Solution:

@RISK can perform a simulation with a workbook protected by a different method if you provide a workbook password by creating a GetPassword function.

Click File » Save As, and next to the Save button click Tools » General Options and specify a password.