Anaplan XL Grids can coexist with protected worksheets in several ways.

Set the Anaplan XL Workbook Options to use your password

In the Anaplan XL > Options > Workbook Options dialog, you can set the Workbook > Workbook protection password. The grids should then be updated as required.

Using the grid on the protected worksheet

The grid can be directly placed on the protected worksheet by following these steps:

    • On the Grid Properties > Appearance tab, deselect Apply formatting and Merge repeating cells.
    • Set all the grid cells to be unlocked. 
    • If the grid can be edited by drilling or other member selection methods, it also unlocks cells to accommodate ‌potential growth.
    • Protect the sheet by enabling these options:
        • Format cells
        • Format columns
        • Format rows

If Format columns and Format rows protection is required, then Grid Properties > Behavior > Resize columns/rows after refresh must be disabled.

Placing the grid on a non-protected worksheet

You can place the grid on an unprotected worksheet and transfer the data to the protected sheet by using the Camera tool or formulas.