Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

EVDRE Formatting: CRITERIA is INPUT and USE is LOCK

Hi

Goal : lock calculated cells for input on a BPC EVDRE input schedule which is dynamic in rows and cols

What should my format range look like and what is my protection setting?

Thx

Bjorn

Former Member
Former Member replied

Hi Bjorn,

You format range should look like the following

CRITERIA EVALUATE IN FORMAT USE PARAMETERS APPLY TO

CALC 123 LOCK DATA

You should lock the cell with the "123" (Format Cells / Protection / set tick in "Locked")

After that, go to the "Workbook Options" and set a password.

Regards,

Marcel

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question