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?

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.