Microsoft forms responses are not syncing automatically to onedrive/sharepoint

Anonymous
2024-10-15T02:03:32+00:00

We used to have an excel system running off the final line of the excel sheet generated by forms.

I have a new tenant and forms is using the new GUI

I send some responses inside forms, but the results are not synced/updated inside my sharepoint/onedrive excel sheet automatically.

It will only work if i click on open result in excel inside the webpage, which will then only update my excel in sharepoint/onedrive.

Please advise how i can get it working again.

Thanks

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

41 answers

Sort by: Newest
Most helpful Newest Oldest
  1. Anonymous
    2024-10-15T05:02:54+00:00

    Dear Deric Chong1,

    Good day and thanks for posting the issue in our forum.

    As you described the issue, your Microsoft forms responses are not syncing automatically to OneDrive/SharePoint.

    I would like to apologize for the issue that you are currently facing now.

    I would like to suggest opening the problematic form in the Microsoft Forms> Responses> Click on three dots beside Open in Excel> Sync all responses to a new workbook

    If the problem persists, can you please check whether the problem happens with a specific form or all forms in your Microsoft Forms?

    Could you also provide some screenshots of the issue?

    You could also check the below links:

    Update to the new solution for syncing forms responses to Excel - Microsoft Community Hub

    How to get missing data in Forms - Microsoft Support

    Appreciate your understanding and patience.

    Sincerely,

    AJ RAJ| Microsoft Community Moderator

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments