I have a table with a column which values can't be edited by users. I can easily configure Dataverse to do so, either inside form by changing column type to read-only or by using Business rules. However I realized that it can by easily avoided by editing records in Excel Online that does not inherit Dataverse security model and while saving it does not respect neither form security nor business rules.
The problem is that I need to show this column in the main view and I need to allow users to edit data in Excel Online. So is there any way to prevent saving changes in a certain column from Excel Online?

Report
All responses (
Answers (