Paste values to a mixed range of leaves and consolidated cells

You can paste values to leaves and consolidated levels in a view, if the paste special feature is enabled.

The paste special is not available by default. It is available on request only, and replaces the standard paste functionality.

How paste special works

Cells that contain pasted values have the same values as the pasted values; they do not change. The values in leaves that are not pasted change to account for the distribution of the values.

Leaves are pasted first, and each cell is held after the update. Then, cells at the next level up (the first-level consolidation) are pasted to, and they too are held, and so on through the levels.