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
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

50 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2025-01-30T16:57:50+00:00

    I agree with others. This is a bug, not a feature.

    We use Power BI to read from OneDrive excel files that are sync'ed with forms. Previously, we'd see the new entries automatically in the Power BI report. Now we don't.

    This is a loss of functionality.

    Was this answer helpful?

    8 people found this answer helpful.
    0 comments
  2. Anonymous
    2025-01-17T06:11:51+00:00

    I used Power automate.

    • One Flow for adding the information from the form to a locally saved excelfile
    • One Flow for regulary updating that excelfile on onedrive.

    Was this answer helpful?

    8 people found this answer helpful.
    0 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
  4. Anonymous
    2025-01-13T09:45:10+00:00

    This is a step backwards, anyone have a workaround?

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments