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

%3CLINGO-SUB%20id%3D%22lingo-sub-386298%22%20slang%3D%22en-US%22%3EMicrosoft%20forms%20won't%20submit%20to%20a%20protected%20sheet%20in%20Excel%20with%20insert%20permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-386298%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20form%20connected%20to%20an%20Excel%20file%20in%20my%20OneDrive.%20I%20locked%20the%20sheet%20to%20allow%20for%20inserts%20but%20not%20deletes.%20This%20resulted%20in%20no%20responses%20being%20written%20to%20my%20Excel%20file%20until%20I%20removed%20protection%20from%20the%20sheet.%20Any%20thoughts%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-386298%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EForms%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMicrosoft%20Forms%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-687008%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20forms%20won't%20submit%20to%20a%20protected%20sheet%20in%20Excel%20with%20insert%20permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-687008%22%20slang%3D%22en-US%22%3E%3CP%3Ehey%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306836%22%20target%3D%22_blank%22%3E%40sootsie74%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3Edid%20you%20get%20a%20solution%20to%20this%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ei%20have%20the%20same%20issue.%3C%2FP%3E%3CBLOCKQUOTE%3E%3CHR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F306836%22%20target%3D%22_blank%22%3E%40sootsie74%3C%2FA%3E%26nbsp%3Bwrote%3A%3CBR%20%2F%3E%3CP%3EI%20have%20a%20form%20connected%20to%20an%20Excel%20file%20in%20my%20OneDrive.%20I%20locked%20the%20sheet%20to%20allow%20for%20inserts%20but%20not%20deletes.%20This%20resulted%20in%20no%20responses%20being%20written%20to%20my%20Excel%20file%20until%20I%20removed%20protection%20from%20the%20sheet.%20Any%20thoughts%3F%3C%2FP%3E%3CHR%20%2F%3E%3C%2FBLOCKQUOTE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1240411%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20forms%20won't%20submit%20to%20a%20protected%20sheet%20in%20Excel%20with%20insert%20permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1240411%22%20slang%3D%22en-US%22%3EDoes%20anyone%20have%20a%20solution%20for%20this%3F%20I%20would%20like%20to%20be%20able%20to%20have%20responses%20submitted%20with%20the%20form%20but%20make%20the%20excel%20sheet%20uneditable.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1242126%22%20slang%3D%22en-US%22%3ERe%3A%20Microsoft%20forms%20won't%20submit%20to%20a%20protected%20sheet%20in%20Excel%20with%20insert%20permissions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1242126%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F422571%22%20target%3D%22_blank%22%3E%40Todd_Edwards%3C%2FA%3E%26nbsp%3Bif%20you%20just%20use%20the%20spreadsheet%20connected%20to%20the%20form%20then%20only%20those%20who%20are%20owners%20of%20the%20form%20can%20see%20%26amp%3B%20edit%20it.%20That%20seems%20the%20most%20sensible%20solution.%20Otherwise%20you%20can%20save%20the%20form%20responses%20via%20a%20flow%20in%20Power%20Automate%20to%20a%20different%20spreadsheet%20that%20only%20you%20can%20access.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%233366FF%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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
Highlighted

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?


 

Highlighted
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.
Highlighted

@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