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-01-16T02:51:37+00:00

    Hello! I am having a similar issue, but I can't get my document to sync at all (either in desktop or excel). When I download a copy of the results, I can see the new responses but it's not automatically syncing in either the online version of excel or the desktop. I have tried to disconnect and sync with a new workbook, but I constantly get an error message that says "Sorry, failed to open Excel online You can still download a copy to view response in Excel".

    Because neither version is syncing I don't know that it's the update that is the issue. Has anyone experienced this and know how to troubleshoot to get the workbook to auto sync (I am fine syncing to the desktop or web version, I just need one of them to auto sync).

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2025-01-16T17:11:34+00:00

    This is so totally unprofessional and unacceptable from Microsoft! They should at least revert back until ALL known issues are resolved!

    Was this answer helpful?

    6 people found this answer helpful.
    0 comments No comments
  3. Anonymous
    2025-01-16T17:29:17+00:00
    1. Could you please check the developer notes to see if or why the auto-sync function has now been removed? I have built multiple reports that were dependent upon this function that has now been removed.
    2. Having to manually go into the form excel file to update means it is NOT automated any more. Maybe you could propose a work around such as making a power automate process that open the excel file allowing it to sync once per day?

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments No comments
  4. Anonymous
    2025-01-16T19:16:46+00:00

    We are using excel sheet to created planner task, Due to synchronizing issue our program failed.

    This problem must be fixed ASAP by Microsoft,

    Was this answer helpful?

    0 comments No comments