Microsoft forms responses are not syncing automatically to onedrive/sharepoint

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

Hi Raj,

Thanks for replying me so quickly. I've done a new form to test, and this is my screenshot of the trying to generate to a new form.

Mine is on a new GUI, so i'm not sure where you want me to generate into a new form.

In the previous version of non updated form, it works, but this doesn't.

Dear Deric,

Thank you for the reply and screenshot.

I have also tired in the NEW GUI, and you can refer to the screenshot below to sync the form in new workbook:

Appreciate your understanding and patience.

Sincerely,

AJ RAJ| Microsoft Community Moderator

Hi AJ,

Thanks for your response, It is the same result, if i do not click this circled part to open the excel in my browser even when there's new responses, the onedrive file on my desktop will not automatically update. I've used forms for the past 3 to 4 years and it was working all fine until recently. Please find a workaround for me as we use it for our office operations automation daily.

Dear Deric,

Thank you for the reply.

Regarding your first concern, "I've used forms for the past 3 to 4 years and it was working all fine until recently."

Previously, there are two ways for forms to sync data to excel workbooks (sync responses in real-time or sync responses only when opening the workbook in Excel for Web). 

However, now there is only one way (sync responses only when opening the workbook in Excel for Web) for forms to sync data to Excel workbooks. **** Microsoft has changed the sync process for all forms.

The following official Microsoft blog has mentioned this change for all forms. You can view it for more details.

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

Regarding your second concern, based on above, since there is only one sync way, please note that Forms data sync to Excel is currently only available in Excel for the Web, not in Excel desktop apps or mobile apps. In this case, it is normal that you need open the linked workbook only in Excel for Web to see the latest responses.

Introducing Forms data sync to Excel

Regarding your third concern, yes, there is a workaround to sync the latest form responses to the workbook in the real-time. You will need to build a Power automate flow you could check the reply from George on July 4^th^ 2024 as mentioned in the following thread:

Why is my Forms Spreadsheet not syncing until I open it? - Microsoft Community

Appreciate your understanding and patience.

Sincerely,

AJ RAJ| Microsoft Community Moderator