A web-based tool in Microsoft 365 that enables users to quickly create surveys, quizzes, polls, and feedback forms.
Hi FM,
I tried to reproduce this behavior by submitting two separate responses with different answers and then comparing them in Forms and Excel. In my test, the answers remained correctly associated with each response in both places, so I could not reproduce the mismatch you described.
Since these responses have already been submitted, I would be cautious about assuming that either the Forms summary or the current Excel workbook is the accurate one. Given the importance of keeping each response associated with the correct participant, I would suggest cross-checking the results in as many available places as possible before making any changes to the data.
First, try opening your form in Microsoft Forms in an Incognito/InPrivate window. Then select Responses > More options (...) > Disconnect and sync to a new workbook and compare IDs 262 and 270 again to see whether the discrepancy remains in the new workbook.
If they still do not match, and your research protocol allows it, you could ask the affected participants to confirm their answers as another point of comparison. If that is not possible or the results are still unclear, I would suggest asking your IT admin to contact Microsoft Support for further investigation.
I hope everything will be sorted out soon.