Lock Excel Sharepoint linked to Microsoft forms

I was able to create a Microsoft form linked to an excel sheet stored in sharepoint. Multiple users will have access to the sheet. I want to lock one column with a password. I select the edit range and set a password for column M, then select the rest of the range to be edited by anyone. Excel advises that changes will not take effect unless I lock sheet. After locking sheet, answers from Microsoft form do not come through to the document. Like if I have locked sharepoint from editing its own spreadsheet as well! I need to have a locked column but I need Microsoft forms to populate the rest whenever we have a new answer. Help?