Update sync in Excel

Question

Dear admin,

We have multiple Microsoft Form failed auto sync to excel when user submit the form.

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

I have refer this solution seems like not working at all. Could you please advise it. Thanks

Thanks and regards,

Sky

Answer 1

Dear User,

Thank you for contacting the Microsoft Community. We are here to assist you

We apologize for the inconvenience you are facing with syncing Microsoft Forms responses to Excel. To assist you more effectively, we need some additional information. Could you please provide the following details:

1. Have you tried syncing the form responses to a new Excel workbook? Is your Excel workbook stored online and accessible?
2. Are there any error messages when the sync fails? Have you checked if the Excel file is locked or checked out by another user?
3. Have you tried clearing your browser cache or using a different browser?
4. Would you consider using Power Automate to create a custom flow for syncing responses?

Additionally, it would be very helpful if you could provide screenshots of the error message and any other relevant information.

Kindly note that 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

Please understand that our initial reply may not always immediately resolve the issue. However, with your help and more detailed information, we can work together to find a solution.

Have a great day and take care! 😊 

Sincerely, 

Naren | Microsoft Community Moderator