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?
We are creating planner task from summited form. Planner getting data and photo from excel spreadsheet. This program only works when excel sheet kept open. Failed programs can be resubmitted after opening excel sheet and synchronizing new data. Any clue to fix this issue?
I have a similar issue, my form does sync, but not all of the information from the form appears in the file. Some information simply does not appear, even when entered in the form. How can I fix this?
were you able to fix this? When I open my excel file on browser it says "10% synced" and is not continuing to sync. I have all my results in forms that I use on a daily basis but I need the shared excel too. All the new entries since the update do not show in the excel file. This is terrible. Can anyone tell me how to get all the results synced?
I can share the workaround I did. It may be specific to my use case.
I had a form, when submitted, "automatically" updated excel with a row with all form details. The excel had a column (not part of form) called "Approval Response".
A flow was triggered whenever the form was submitted; and it waited for approval. Once approved by the approvers, it updated the approver's response in the excel row column "Approval Response".
Since the new Microsoft update, as the row was not there, the flow was failing the excel update. The initial workaround was asking the approvers to open the excel, check the record is there and then process approval for that record.
**The fix:**I created a new sheet with ID, Approval Response columns in a new table(Table2). The flow, instead of updating the excel row, inserts the ID, Approval Response into Table2. I updated the main table(data coming from form) to have "=VLOOKUP([@ID],Table2[#All],2,FALSE)" for all the rows of the "Approval Response" column. I checked that any new row created will automatically have the formula in the column. In this way, the flow does not fail; and the form is up to date as it was before. Whenever anyone opens the excel, it updates the excel and has right value in "Approval Response"
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.