Forum Discussion
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...
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
