Release a consolidation hold on a single cell or range

You can release a consolidation hold on a single cell or range.

Procedure

  1. Select the cell or range of cells.
  2. Right-click the cell or range.
  3. Click Holds > Release consolidate.

Results

The consolidated value can now reflect any changes that you make to the underlying leaf values.
Note: To release all holds that you applied to all cubes, right-click any cell in any cube, click Holds > Release all holds.