Show TOC

To lock cells Locate this document in the navigation structure

Context

You can lock input-ready crosstab and total cells in Analysis. A locked cell can not be changed manually when the corsstab is recalculated. If you execute a planning function or sequence the locked cells are unlocked automatically.

Note Microsoft Excel cells are always input enabled. That means you can also enter values in the locked cells of the data source. These values will not affect your planning though.

The cells are locked for the current user session only. You can also unlock the cells during the session.

Procedure

  1. Select the crosstab cells you want to lock.
    The selected cells have to be input enabled and have not been changed since the last recalculation.
    If you select a mixture of input-ready and already locked cells, all selected cells will be locked.
  2. Choose Lock Cells in the planning group.
    You can also use the context menu to lock and unlock the cells.

Results

The selected cell are locked for changes. The locked cells are displayed in a different cell style.

To unlock the cells, select all cells you want to unlock and choose Unlock Cells.