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

Occasional Visitor

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 Replies

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?


 

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.

@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