About Value Lock Management

How to prioritize locks and data entry for table cells.

When you lock a table cell, the value in that cell will not be updated when you make changes to the data. By default, data entry processes have lower priority than cell locks. If you want to give data entry processes higher priority, you can change the order of the locks.

Set Lock Priority

You can rearrange locks in the Value Lock Management panel to change their priority. After you move one lock, priority values appear for all locks. The first item in the list (lock or data entry process) shows priority 1, which is the highest priority.

To rearrange the locks, use the following procedure.
  1. Select your table.

  2. From Tools, select Value Lock Management.

  3. In the Value Lock Order section, select a lock and drag it higher or lower.

    When you release the lock, each lock now shows a value: 1 is the highest priority.

  4. Continue to drag the locks to your desired positions in the list.

  5. When you are finished and want to close the panel, select Done.

Set Multiple Locks

You can set locks individually in the table (by selecting a cell and then using Lock cell for each lock) or you can use the Value Lock Management panel to quickly lock multiple cells.

To use the panel to apply locks, use the following procedure:
  1. Select your table.
  2. From Tools, select Value Lock Management.
  3. In the Value Lock Management panel, select (Create Locks).
  4. Select the cells in the table to apply locks to.
  5. When finished setting locks, select (Create Locks).
  6. To close the panel, select Done.