Skip to Content

How to lock specific cells at BPC 10.0

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,


Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jul 26, 2012 at 09:44 PM

    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,

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 27, 2012 at 12:16 PM

    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.



    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.