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: Newest
Most helpful Newest Oldest
  1. 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
  2. Anonymous
    2025-01-17T00:17:52+00:00

    I'm having the same issue, is not sustainable to be opening the file each time I have to update a PowerBI report, any suggestions on how to solve this?

    Carlos

    Was this answer helpful?

    0 comments
  3. 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
  4. 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