Option to have a user unable to type in Pivot Table without protecting the sheet ?

[karmapala]

I've searched on the internet, for example I found this link which teach on how to disable some feature in a pivot table using VBA. But I can't find what I want.

The problem is, sometimes the user accidentally type in the pivot table without knowing it.
For example, in a Row Label field there is "invoice number" field with thousands of item, then a user accidentally type something in a cell of this column.

Later on when I check this pivot table, I found that cell value is not the invoice number anymore.

Because even after I refresh the pivot table, the cell with the wrong value is not updating back to the original one...

zzz.gif

then it gives me headache as I need to have this cell value back to the correct invoice number by comparing with the data source to find which one is missing.

I realize that the pivot table can be protected through an option in worksheet protection, but I don't want to use it as far as possible - because then the user need to unprotect each sheet which has a pivot table with the same data source in order to refresh the pivot table, then protect it again.

So I wonder if there is a pivot table option to make the pivot table refuse to be typed - something like when a user type in the Values field it show a message like this :

zzz2.gif

Even if it has to be via VBA I would like to know it.

Any kind of respond would be greatly appreciated.
Thank you in advanced.

[TechRetard]

As far as i am aware this is not possible without VBA... need to unprotect then protect again

check out this page https://www.pivot-table.com/2017/03/...otected-sheet/

[karmapala]

@TechRetard,

Yes I realize now that it can't be done without the unprotect-protect process.
Thank you for your respond.