Share via

New Forms Sync

Anonymous
2025-02-06T12:25:58+00:00

Hi,

new solution of MS Forms-Excel sync is a disaster. In a scenario, when you use the forms to collect data and then process them in excel this has brought the necessity of opening the xls file online to have it synced with actual Forms data and disrupted the chain that was automatized so far. As I have noticed the disappointment is more widespread and hope that MS will bring some other option, without the need of opening xls file to have it synced.

David.

Microsoft 365 and Office | Excel | For business | Windows

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

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-02-06T12:59:09+00:00

    Dear Dave,

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

    I'm sorry to hear about the frustration you're experiencing with the new MS Forms-Excel sync solution. This issue has indeed been a common concern among users. The new sync solution requires opening the Excel file online to update it with new Forms responses, which has disrupted many automated workflows.

    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.

    I can understand the situation. I suggest you to use Power automate flow as a workaround, same workaround is being utilize by other users as well as mentioned by George on July 4^th^ 2024 in the following thread.

    This is due to a design change and currently, there isn't an out-of-the-box solution to address this. However, our product developers are always open to user suggestions, so I encourage you to submit your feedback on our Data Sync - Schedule · Community. This way, they can consider your ideas for future improvements.

    Please accept my apologies for redirecting you to the related team support, Since the moderators in this community are not authorized to cast votes on your behalf, we kindly ask you to submit your vote directly to the developer team for prompt and effective assistance.

    I hope you are staying safe and well! Have a great day and take care! 😊 

    Sincerely, 

    Naren | Microsoft Community Moderator

    Was this answer helpful?

    0 comments