Home → Troubleshooting → @RISK for Excel: Simulation → "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