You can release a consolidation hold on a single cell or
range of cells.
Procedure
-
Select the cell or range of cells.
-
Right-click the cell or range.
-
Click Holds > Release consolidate.
The consolidated value now can reflect any changes that you make to the underlying leaf
values.
Note: To release all holds you applied in a websheet, right-click any cell in the
websheet and click Holds > Release all holds.