When you work with the Function wizard, the collaborative edit mode is suspended.
In this case, a user can restrict other users from entering formulas when that user:
•Deletes the cell being edited or a sheet with the cell being edited.
•Adds a pivot table or table header to the range with the cell being edited.
•Sets the protection of the cell being edited or the sheet with the cell being edited.
If the user has restricted the input of formulas in any way, after the other user confirms the changes in the Function wizard window:
•The changes will not be applied if the cell has been deleted.
•The cell will return to the state before using the Function wizard if it had any content other than a formula.
•The cell that contained a formula before using the Function wizard will be cleared.
If there were no actions restricting formula input, after confirming the changes in the Function wizard window, the new formula will replace any changes made by other users.