How to protect only specific columns in table?

[jaryszek]

Hi Guys,

i want to protect only chosen columns in table because i have there formula and do not want user to change it.
But issue is that after protecting table column i can not add new rows to the table.

Why?
How to avoid the issue?

Best,
Jacek

[PeteABC123]

You can try using CF which will allow rows to be added, you might give it a try. It might help.

https://www.exceltip.com/excel-secur...ted-sheet.html

Pete

[jaryszek]

Hi Pete,

awesome solution. It can help me very much!
Thanks.

What does it mean

=""

as data validation?
It is exatly write for formula syntax in Excel or some kind workaround?

So in naturl Excel protected worksheeet it is not possible i think?
I tried to do this but i can not add new rows to the table.

Best,
Jacek

[TechRetard]

"" means blank, i.e. no text. So when data validation is looking for "" or blank, anything that is entered is by definition NOT blank so it throws the error. If however a user just clicks on the cell and hits delete so the cell is in fact blank, it will not throw an error, because the validation of the data is correct.

[jaryszek]

Thank you TechRetard,

understood know.

Jacek

[jaryszek]

Hi Guys,

for people with the same problem:

Screenshot_22.png

I created formula from link above and Excel converted it to blank place like in the screen above. Interesting but working

Best,
Jacek