Select a cell, and then open the distribution menu.
Select Lock this cell.
Select Lock all children to lock descendant cells.
Verify that locked cells appear grayed out in the planning sheet.
Update a parent value to verify the effect on locked descendant cells.
Verify that unlocked descendant cells reflect the updated value while locked cells remain unchanged.
Open the Model ribbon.
Open the Rules dropdown.
Select Locking rule.
Enter a name for the locking rule.
Select measures for the locking rule by using the Measures dropdown.
Select the Rule Type field.
Select the checkbox to apply the rule to child rows and columns.
Open the Rows selection dropdown.
Select All Rows to apply the locking rule to all rows.
Select Custom to choose specific rows.
Select rows by using the checkboxes.
Select the Filter option to configure row filters.
Configure row filters by using the dropdown fields.
Select Submit.
Open the Column Selection dropdown.
Select Open Period to apply the rule to open-period columns.
Select Period Range to configure a date range.
Select a date range by using the calendar.
Select Custom to choose specific time periods.
Select time periods by using the checkboxes in the Selection tab.
Select the Filter option to configure column filters.
Select Create.
Open the Rules dropdown in the Plan ribbon.
Select Manage rules.
Manage locking rules by viewing, editing, duplicating, deleting, or disabling existing rules.
Last updated 1 month ago
Was this helpful?
