The responses from Forms are no longer automatically syncing to Excel.

Anonymous
2025-01-08T05:29:30+00:00

The responses from Forms are no longer automatically syncing to Excel.

I received an email stating, "Please update your form before January 13, 2025 to continue seeing the most recent Forms data in Excel with the new and improved sync. If you don't update, your responses won't continue to sync after this date. To start the update, open your Form from forms.office.com or click the button below. Thanks for using Forms."

After updating, I saw the message in Excel: "The sync with Forms has been updated. This workbook will continue to sync with the latest responses from Forms. The updated sync currently works only in Excel for the web and will soon be available on desktop. Once responses are synced, you will be able to view them on both web and desktop. This update cannot be undone."

However, even after the update, it does not sync unless I open Excel in the browser.

I would like it to sync automatically again without having to open it in a browser like before.

Does "it will soon be available on desktop" mean that eventually, it will sync automatically without having to open Excel?

How long should I wait?

By the way, since the Forms were created from a Teams channel, they are likely group forms.

This is the screen when I updated it.

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 No comments
Answer accepted by question author
Anonymous
2025-01-26T19:26:40+00:00

Sorry about being thick. Why do you have two flows. Why could the one flow not do both?

Was this answer helpful?

3 people found this answer helpful.
0 comments No comments

50 additional answers

Sort by: Newest
  1. Anonymous
    2025-01-22T14:54:22+00:00

    I think having to manually go into a spreadsheet to sync it kind of defeats the object does it not? I have had a form linked to Power BI for over a year and had no issues but now we are unable to review responses when they land. A real downgrade on performance - i hope you fix it soon as the suggestion to build a Power Automate flow to bridge the gap is not really an acceptable solution

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments
  2. Anonymous
    2025-01-20T22:32:28+00:00

    We have the same issues now that this "improvement" has been deployed.

    Our automation that relies on the Excel sheet being populated is now (after a couple of years seamless operation) useless.

    This is a downgrade and causing unnecessary headaches.

    Please put the sync back so our business process works again, thanks.

    As a work around I have left the Excel for web sheet open and enabled an "Auto Refresh" extension at 20 second intervals.

    Dumb to have to do but at least the Excel sheet is sync'd and up to date.

    Was this answer helpful?

    3 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2025-01-20T17:15:22+00:00

    This is quite inexcusable. I hope Microsoft blames this on a decision made by Copilot and not their actual development team. Who rolls out a "new and improved" sync feature that requires humans to pretend to be a computer? Clearly this feature was not ready. The dev team that worked on this must have been close to a promised deadline and rolled out a barely functioning version just to look good enough on paper. Blunders like this are what makes G Suite more attractive to business that actually want their processes working. SMH.

    Was this answer helpful?

    7 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2025-01-17T07:14:43+00:00

    We received the same but my question is more about who receives the responses to forms created via Microsoft Teams. Do the responses get sent to all members of the Teams group where the form was created in?

    Was this answer helpful?

    0 comments No comments