This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Sorry about being thick. Why do you have two flows. Why could the one flow not do both?
123456
This is a step backwards, anyone have a workaround?
Dear Microsoft Team,
I have a question regarding the changes to Microsoft Forms syncing behavior with Excel.
Since the recent update, we are facing significant disruptions in our workflow, and I would appreciate further clarification.
These updates have significantly impacted our workflow:
Previously, I used Power Query in Excel to extract data from Forms response Excel files stored in OneDrive for Business. This method allowed me to efficiently consolidate data from multiple Forms into a single Excel file, which we use for visualization and reporting on our dashboard. However, since the update to the new sync method, this process no longer works. I can't keep open all the forms every hour to make the live screens show the latest information.
The inability to maintain an automatically updated summary file became a major challenge for us. I understand from your previous answer that there is no ETA for when desktop Excel will support automatic syncing.
In the meantime, we are using a workaround that involves Power Automate to add a row to an Excel file whenever a new response is submitted in a form. Additionally, another flow updates the file automatically in OneDrive every minute.
However, I would like to know if there are any planned updates or alternative solutions to restore the seamless automation we had before.
Thank you for your attention to this matter. I look forward to your response.
Can this be raised as an Issue rather than Feedback as it has broken a number of our Power Automat flows that have "Update Row' actions. Due to the automatic sync not working any flow we have with an 'Update Row" action is failing to locate the row as the data in the workbook is stale. This needs to be resolved as a fix and not suggested as a potential upgrade or improvement.