The locking of specific slices of data follows the same rules as the standard Anaplan XL formatting rules defined in the AnaplanXLFormats sheet. 

The examples below use a grid report. For example, you can create a grid report with the Dates dimension in columns and the Accounts in rows. 

You may want to unlock all the lowest-level accounts in a grid for your users. 

To unlock lowest-level accounts: 

  1. Right-click on an account member, choose Anaplan XL > Formatting > Format this Member or Format this Level, and apply formatting.
  2. Go to the AnaplanXLFormats worksheet. 
  3. Within the Slice highlight (formatting by member or measure) section, select the level-leaf cell for Accounts, right-click, choose Format Cells, select the Protection tab, uncheck Locked, and choose OK.

Define the format for all years in the Date dimension. For example, you can set a white background for parent cells and a yellow background for the leaf accounts.

To lock all the years:

  1. Right-click on a Date member, choose Anaplan XL > Formatting > Format this Member or Format this Level, and apply formatting. 
  2. Go to the AnaplanXLFormats worksheet. 
  3. Within the Slice highlight (formatting by member or measure) section, right-click on the Date member, choose Format Cells, select the Protection tab, uncheck Locked, and choose OK for the appropriate Level for the period or date hierarchy.

Define the format for the column or month. To unlock a specific column or month:

  1. Right-click on a column or month member in the grid, choose Anaplan XL > Formatting > Format this Member, and apply formatting. 
  2. Go to the AnaplanXLFormats worksheet. 
  3. Within the Slice highlight (formatting by member or measure) section, right-click, choose Format Cells, select the Protection tab, uncheck Locked, and choose OK for the specific period or date member.

You can choose to lock a specific cell.  To do so:

  1. Right-click a cell in the grid, choose Anaplan XL > Formatting > Format this Cell, and apply formatting. 
  2. Go to the AnaplanXLFormats worksheet. 
  3. Within the Slice highlight (formatting by member or measure) section, right-click the value listed in the Hierarchy 2 column, choose Format Cells, select the Protection tab, check Locked, and choose OK for the specific period or date member.

See Formatting Grids and Level-based formatting for more details.

Note: If you try to modify a locked cell, a message will appear stating that the Writeback cell is locked and showing its location.