Skip to Content
author's profile photo Former Member
Former Member

How to make some cells non editable in excel for a key figure which is defined as editable


Our requirement is to make certain cells of a key figure as non editable in the excel front end. This key figure is essentially defined as editable in configuration. Some use cases for this requirement are:

1. Price changes should not be possible at aggregated levels but should be possible at dis-aggregate level

2. A key figure becomes non editable if some other key figure is populated

For similar requirements in DP we used Cell_input() operator. Do we have something possible for IBP as well?

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Sep 14, 2016 at 10:43 AM

    Hello Vivek

    There is an option to use the EPM formatting sheet in connection with a password protection of the template.

    There are 2 steps.

    1) Add your key figure in your EPM formatting sheet, in the list of "Formatting on Specific Member/Property". Here you have that "Use" column, where you specify which cell format should use. Deselect everything and just check the "Lock" box from "Protection" formatting. After you've done this, go back to your planning view

    2) in the IBP add-on, go to tab "Template Admin" -> Advanced -> EPM Sheet Options -> select Protection tab

    Here you select the radio button that says "Protect Active Worksheet", type in your password and you're done. You can also add/remove some other restrictions of the users in the "Worksheet Protection" area of this window.

    I hope this helps.



    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Sep 14, 2016 at 06:11 AM

    Hi Vivek,

    For your point 1, i can suggest to make the key figure as 'system editable'. This will allow you to upload the key figure at aggregated level and system will store it at base planning level as per the dis aggregation expression.



    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.