Diagnosis
It is not possible to make entries in all the (not locked) data cellsand their total cells at the same time because the value in the totalcell will not automatically be the same as the sum of the individualdata cells. This is also the case if you want to change the value of atotal or a subtotal and all the subordinate subtotals are locked.

System Response
The entries are returned to their original values.

Procedure
If you want to change the value of a total cell, your can only changen-1 (not locked) data cells that belong to this total at the same time.Data cells from locked subordinate subtotals are also always lockedwhen entered in a superordinate total or subtotal.