Forum Discussion
How can i protect a calculated column in a table from being edited but allowing users to add rows?
Hi, I have a simple example of a data entry form (on an excel table) with 4 columns for entry of quarterly financial data. i have a 5th column that adds up the 4 quarters into an annual cost per line...
Here is a solution with data validation.
This presented procedure protects the cells from accidentally overwriting the cells.
However, the locked cell can still be deleted with the Delete key.
Protected cells can also be overwritten using the copy and paste function.
The function presented does not represent particularly good protection,
but it is sufficient in practice in many cases.
Otherwise it would have to be done with VBA, but it takes time,
which I unfortunately don't have available.
Hope I was able to help you
I know I don't know anything (Socrates)
I am looking for something more robust than that.
Is there really no inbuilt way in Excel to be able to instert a row into a table while protecting a calculated column? That seems such a basic need?
Is there really no inbuilt way in Excel to be able to instert a row into a table while protecting a calculated column? That seems such a basic need?
- I don't know of any other approach without VBA, but this doesn't have to be the case, it may be, I don't know, that there could be other ways, but these are beyond my knowledge.
You do need VBA for this, sorry!
