A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
Sorry about being thick. Why do you have two flows. Why could the one flow not do both?
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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?
Hi Sophia,
We have 30 forms collecting 7,000 to10,000 responses monthly here at Monster Energy. Is there a way to create the auto sync using an alternative method? Prior to the Jan 13th update this was not an issue.
Thank you
Does leaving the web version of the file open really work?
Seems to - I've got this running to keep the sync updated.
It stops when I shut down so will need to leave a computer running 24/7...
Like I said, it's dumb but they broke a perfectly good system
Nope. Look like that about 2 hours after the last input on the spreadsheet, the sync between Forms and the Excel sheet seems to stop. Paradoxically, the best WA at the moment is to use a browser extension that automatically refreshes the page every n minutes.
Good Idea, how browser extension that automatically refreshes the page every minutes?
Did you create a power automated program to do this? Can you share steps for that?