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: Oldest
  1. Anonymous
    2025-02-06T04:04:53+00:00

    Yes, but you if your model is connected to the desktop file, you have to be sure it has already upload the changes made in the web version.

    Carlos

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2025-02-14T05:35:53+00:00

    Thank you all for your advice and replies.

    I was extremely anxious and worried, thinking that the sync issue was due to my own mistake.

    However, thanks to all of you, I was encouraged and found the solution.

    I solved this issue using Power Automate.

    I hope this can be helpful for those who are facing the same problem.

    Here is the specific flow I used:

    Since the response time in Forms is crucial for me, I needed to convert the time zone.

    However, if the response time is not important for you, the conversion may not be necessary.

    "When a new response is submitted"

    ↓

    "Get response details"

    ↓

    "Convert time zone"

    ↓

    "Add a row into a table"

    This flow is simple, takes less than a second to execute, and has no failures.

    Thank you!

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2025-03-11T13:45:06+00:00

    Same here. This update removed a feature (auto sync) that was critical to our workflow. I guess I'll be looking to someone other than Microsoft to replace our current processes. This is very disappointing!

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments
  4. Anonymous
    2025-03-11T13:47:04+00:00

    This "update" removed a feature (auto sync) and diminished the abilities of Forms. Auto sync was critical to many of our company's workflows. I guess I'll be looking to someone other than Microsoft to replace our current processes. This is very disappointing! Why would you remove features in a supposed "upgrade"?

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments No comments