How to lock specific cells at BPC 10.0

[mauriciobrandon]

Hi experts,

I need to create an input form with the following format of rowsXcolumns (ACCOUNTx(TIME,DIMENSION_B)):

The brown cells are meant to be locked for user editing, as they are calculated by formulas and user should not chenge that definition. I tried to lock using excel's spreadsheet protection. It worked, but when I clicked at "EPM > Save and Refresh Data", an error message shows:

Is there a way of locking a cell for editing and not getting this error message?

Best regards,

Mauricio.

[Former Member · Accepted solution]

Hi Mauricio,

For locking the cells in bpc you should not use the standart excel locking. For doing so, you need to enter to the options menu in the epm menu and select the las tab that says "Protection".Then select one of the radio buttons of your desire protection and put your pass.

Hope it helps,

[mauriciobrandon · Accepted solution]

Thanks, Guillermo! It worked, but I still had to lock/unlock cells before doing that procedure, as I would with excel formatting.

Best regards,

Mauricio.

[former_member205115]

Hi Mauricio,

To lock specific cells you need to do so in the EPM 10 formatting sheet, under the EPM tab (next to the report editor).

You can then choose which rows, columns etc you wish to lock by right clicking on the cells, choosing EPM, then selecting lock cells.  Then protect the worksheet/workbook as Guillermo says.

In your case, there is a line in the EPM formatting sheet that refers to calculated members which can be locked.

Best,

Chris