Share via

MS Forms - Can the Excel file that holds all MS Forms responses be overwritten manually?

Anonymous
2024-10-21T09:28:06+00:00

If someone goes into the Excel file that is synced with MS Forms responses, and makes changes manually in the Excel, are these changes permanent? Or will the original MS Form responses get reinstated into the Excel in the next sync?

If changes are permanent, is there a way we can retrieve back the original form responses?

Microsoft 365 and Office | Microsoft Forms | For business

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2024-10-21T11:57:11+00:00

Hi Amanda_C1,

Thank you for your questions regarding the MS Forms and Excel integration.

Yes, any changes you make directly in the Excel file will remain intact and will not be overwritten by future syncs. However, if you wish to revert to the original form responses, you can do so by clicking "Resync to a new workbook" from the Forms response page. This will create a new workbook with the original data. See my testing results for your reference.

  1. I created a form and fill 1 answer to it.

Opening the workbook, I manually made some changes.

Then I closed the workbook and submitted the 2nd answer. The changes did not disappear.

I then went to the forms response page and clicked "disconnect and sync to a new workbook".

A new workbook is created with correct responses.

Feel free to reach out if you have any further questions or need assistance!

Best regards,

Sophia

Was this answer helpful?

3 people found this answer helpful.
0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2024-10-22T01:15:38+00:00

    Thanks, Sophia

    Was this answer helpful?

    0 comments