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.