how allow cells to be updated only automatically

Jasmin · Sep 20th 2021

How can I protect some cells so that no one can change them manually?
Of course I am updating them via a formula from another cell

If I do LOCK we cannot update them automatically.

**royUK** · Sep 20th 2021

Of course you can

Jasmin · Sep 23rd 2021

ok but how ?
Suppose I write a row & after the -update, I want to lock it..is there a way to do it?

**royUK** · Sep 23rd 2021

Lock the cells that update and possibly the formulas. Leave the cells that feed into the formula unlocked.

An example workbook would help us give a better answer.

Participate now!