Microsoft forms won't submit to a protected sheet in Excel with insert permissions

[sootsie74]

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 protection from the sheet. Any thoughts?

[#2]

hey @sootsie74 

did you get a solution to this?

i have the same issue.

---

@sootsie74 wrote:

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 protection from the sheet. Any thoughts?

---

[#3]

Does anyone have a solution for this? I would like to be able to have responses submitted with the form but make the excel sheet uneditable.

[#4]

@Todd_Edwards if you just use the spreadsheet connected to the form then only those who are owners of the form can see & edit it. That seems the most sensible solution. Otherwise you can save the form responses via a flow in Power Automate to a different spreadsheet that only you can access.

Rob
Los Gallardos
Microsoft Power Automate Community Super User