Asynchronous and synchronous locking mechanism

There is provided a system for dynamically updating data in dataset, comprising: at least one processor executing a code for: receiving an indication of trigger for a change of a first cell of cells of a dataset, updating the first cell according to the trigger, determining a second cell dependent on the first cell, sending to the second cell, an event message indicating the update of the first cell, locking a column of cells that include the second cell and other cells, and re-computing values of the second cell and other cells of the locked column, by performing a batch update of the cells of the locked column according to the event message, and according to additional event messages sent to the cells of the locked column that received before the locking and/or received during the locking.