How do I solve issues with Microsoft Forms updating a connected Excel Sheet?

Question

I created a Form from a Worksheet from the Insert tab. Everything is stored on SharePoint. There has been a few issues with responses to the Form not showing up in the Spreadsheet. Even after going to the Form responses and selecting "Open in Excel", several responses are missing (i.e. the response ID's go from 101 to 110) However, I submitted a trial response this morning and it worked normally (still missing sporadic responses from earlier) They appear in the Form responses but do not show up in the Spreadsheet. I have a coworker who leaves the Spreadsheet open at all hours. Could this prevent responses from being sent? If so, how do I maintain a Spreadsheet that allows editing but also receives Forms submissions? Would it work if I have 2 sheets, 1 for Forms responses and link it to another sheet that can be edited?

Thanks,

Answer 1

In this way, sync all responses to a new workbook should work. I have no idea why it is not sync.

You may send feedback to Microsoft.

Send feedback to Microsoft with the Feedback Hub app - Microsoft Support

Answer 2

It is Microsoft Forms. I just created the form from the Insert tab in Excel instead of starting from the Microsoft Forms app. This way the Microsoft Form and Excel sheet are automatically linked.

Answer 3

How to get missing data in Forms - Microsoft Support

Use Microsoft Forms instead of Excel form.

Answer 4

Right now it is setup to only allow people within my organization to respond to the Form. Do I need to select "Anyone can respond"? If not, are there any recommendations on how to resolve this?

Answer 5

It is form limitation when the excel file is shared.

You may send feedback to Microsoft.

Your Feedback makes Office Better