HomeTroubleshooting@RISK for Excel: Simulation"Cannot make a sheet to hold correlation information in protected workbook"

4.31. "Cannot make a sheet to hold correlation information in protected workbook"

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

I protected my workbook with a password, by clicking Protect Workbook on Excel's Review tab. When I try to run a simulation I get this error message:

Cannot make a sheet to hold correlation information in protected workbook

followed by my workbook name. I click OK, but the simulation does not run. By the way, some of my distributions are correlated.

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.

There is another form of workbook protection in Excel. Click File » Save As, and next to the Save button click Tools » General Options and specify a password. @RISK can perform a simulation with a workbook protected by that method, if you provide the workbook password by creating a GetPassword function.

Last edited: 2018-03-09

This page was: Helpful | Not Helpful