Forum Discussion
sootsie74
Mar 24, 2019Copper Contributor
Microsoft forms won't submit to a protected sheet in Excel with insert permissions
I have a form connected to an Excel file in my OneDrive. I locked the sheet to allow for inserts but not deletes. This resulted in no responses being written to my Excel file until I removed protecti...
Guirguez
Mar 05, 2024Copper Contributor
sootsie74 I had the same issue, but on Manage protection>Options, if you allow to "Insert Row" responses are appearing correctly. Is the only way i have found to work this around while protecting the rest of the sheet from other users not editing specific cells. I hope this works for you.
Best